Episode 130
pg_squeeze
Postgres FM · Nikolay Samokhvalov and Michael Christofides
January 10, 202536m 26s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Michael and Nikolay are joined by Antonín Houska to discuss pg_squeeze — what it is, how it started, some of its features, and hopes of getting the functionality into core.
Here are some links to things they mentioned:
- Antonín Houska https://postgres.fm/people/antonin-houska
- pg_squeeze https://github.com/cybertec-postgresql/pg_squeeze
- Cybertec https://www.cybertec-postgresql.com
- pg_repack https://github.com/reorg/pg_repack
- Introducing pg_squeeze (by Kaarel Moppel) https://www.cybertec-postgresql.com/en/introducing-pg_squeeze-a-postgresql-extension-to-auto-rebuild-bloated-tables
- pg_squeeze is included in the PostgreSQL APT packages https://wiki.postgresql.org/wiki/Apt
- pg_squeeze is included in the PostgreSQL Yum packages https://yum.postgresql.org
- pg_rewrite https://github.com/cybertec-postgresql/pg_rewrite
- VACUUM FULL / CLUSTER CONCURRENTLY patch https://commitfest.postgresql.org/51/5117
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With special thanks to:
- Jessie Draws for the elephant artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology