TOAST | Postgres.FM 035 | #PostgreSQL #Postgres podcast

Michael and Nikolay discuss TOAST (The Oversized-Attribute Storage Technique) — what it is, how it works, and some general things to be aware of.

Here are links to a few things we mentioned:
* TOAST docs https://www.postgresql.org/docs/current/storage-toast.html
* TOAST wiki https://wiki.postgresql.org/wiki/TOAST
* Hussein Nasser on rows per page (Twitter) https://twitter.com/hnasr/status/1627876515491766273
* Toasting in action (dbi services blog) https://www.dbi-services.com/blog/toasting-in-postgresql-lets-see-it-in-action/
* Interview with Peter Zaitsev (Postgres TV) https://www.youtube.com/watch?v=curz6Tx81FU
* Building columnar compression in a row-oriented database (Timescale blog post) https://www.timescale.com/blog/building-columnar-compression-in-a-row-oriented-database/
* The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (blog post by Haki Benita) https://hakibenita.com/sql-medium-text-performance
* PostgreSQL at Scale: Saving Space Basically for Free (blog post by Braintree on column Tetris) https://medium.com/paypal-tech/postgresql-at-scale-saving-space-basically-for-free-d94483d9ed9a
* postgres_dba alignment padding query https://github.com/NikolayS/postgres_dba/blob/master/sql/p1_alignment_padding.sql

-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides

~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard

~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.