News for hackers. Stuff that matters.

A comment on Pgroll: zero-downtime, undoable, schema migrations for Postgres. Parent comment

Re:Pgroll: zero-downtime, undoable, schema migrations for Po... by darkwater on Tuesday October 03, 2023 @05:21PM (#37757740)
Maybe this is explained somewhere in the docs but I'm lazy: how does it cope with possible performance issue in highly trafficked tables? Can you somehow control the backfill speed if it's taking up too much I/O?
[ Parent | on HN ]
Re:Pgroll: zero-downtime, undoable, schema migrations for Po... by surjection on Tuesday October 03, 2023 @05:33PM (#37757863)
There's nothing about this in the docs :)

Backfills are done in fixed size batches to avoid taking long-lived row locks on many rows but there is nothing in place to control the overall rate of backfilling.

This would certainly be a nice feature to add soon though.

[ Parent | on HN ]