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/curre... TOAST wiki https://wiki.postgresql.org/wiki/TOAST Hussein Nasser on rows per page (Twitter)   / 1627876515491766273   Toasting in action (dbi services blog) https://www.dbi-services.com/blog/toa... Interview with Peter Zaitsev (Postgres TV)    • Interview: Peter Zaitsev, Founder of Percona   Building columnar compression in a row-oriented database (Timescale blog post) https://www.timescale.com/blog/buildi... The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (blog post by Haki Benita) https://hakibenita.com/sql-medium-tex... PostgreSQL at Scale: Saving Space Basically for Free (blog post by Braintree on column Tetris)   / postgresql-at-scale-saving-space-basically...   postgres_dba alignment padding query https://github.com/NikolayS/postgres_... ------------- What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / 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.