The only scalable delete in Postgres is DROP TABLE
24 points by typesanitizer
24 points by typesanitizer
I modified pg_repack to both debloat and delete rows in a table. Works fine on 100GB+ tables.
The article says that pg_squeeze is a "more modern version" of repack
It's not that simple, there are trade-offs to both approaches, which are very different in the underlying mechanism (logical replication vs trigger to log changes happening while the table is being debloated).
Neat!
I’m amused that the article suggests deleting by copy-and-drop, which is a very basic DIY sketch of how pg_repack works.