Support pg_squeeze extension with Postgres by default
C
Christopher Molozian
The new Managed Service for Postgres from Digital Ocean is great. The default bundled extensions are much more practical (smarter) than what's offered with CloudSQL for Postgres. The pg_repack extension is an example which is not available on that alternative service. It's extremely valuable to repack tables and indexes which are under bloat in certain concurrent write workloads often seen with mobile apps and games in production with no live downtime (i.e. no unavailability to read/writes).
There's a recent extension that is intended to be a competitive alternative to pg_repack called pg_squeeze. Some information on the announcement and design of the extension is available online:
Initial announcement - https://www.postgresql.org/message-id/f7288807-acf0-0ef6-0864-94cad76f9a26%40cybertec.at
A major advantage of it over pg_repack is that it can be scheduled to execute automatically on tables with the use of the Postgres background worker pool. It also uses logical replication from Postgres internals rather than a table trigger to apply changes that occur to a table while it's being squeezed. There is no need to run a command line tool to execute table or index packing on the database. The license terms for the extension also look suitable for use with a Managed service.
I would like to recommend this extension be heavily considered for inclusion by default with Postgres environments on DO.
Pan Teparak
I would like this feature too, as the OP mentioned it can be used as a automatic schedule.
This post was marked as
open