[lukeasrodgers]

This is a nice tool to add to one’s Postgres toolbelt. However, when I saw the heading “Benefits of pg_osc” I hoped for a corresponding “drawbacks” or “tradeoffs” section but there doesn’t appear to be, at least on this page. The big one seems to be that this tool creates a copy of your original table (like MySQL Large Hadron Migrator, IIRC) which can be problematic if you are disk constrained and/or your table is very large which is more likely to be the case if you are reaching for specialized tools like this, I think. It would be great if instead some of these operations were supported safely with almost zero-cost the same way eg postgres 11 added support for safely adding new columns with default values. That may be beyond the capacity of an extension, however.

[elchief]

there's a "limitations" toward the bottom