This week we release two improvements to PostgreSQL indexers.

This new release adds support for batching writes to Postgres. This changes follow the MongoDB changes described in the previous changelog. Developers can use the --batch-seconds flag to flush data to PostgreSQL at the provided interval, reducing the number of writes to the database. Notice this behavior is used only for finalized blocks, live blocks will always be flushed to database as they are produced.

The PostgreSQL sink has now a new uniqueColumns: boolean option to control how insert conflicts are handled. If the flag is true, the insert query will ignore any conflict.