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 www.postgresql.org/docs/curre...
* TOAST wiki wiki.postgresql.org/wiki/TOAST
* Hussein Nasser on rows per page (Twitter) / 1627876515491766273
* Toasting in action (dbi services blog) www.dbi-services.com/blog/toa...
* Interview with Peter Zaitsev (Postgres TV) • Interview: Peter Zaits...
* Building columnar compression in a row-oriented database (Timescale blog post) www.timescale.com/blog/buildi...
* The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (blog post by Haki Benita) hakibenita.com/sql-medium-tex...
* PostgreSQL at Scale: Saving Space Basically for Free (blog post by Braintree on column Tetris) / postgresql-at-scale-sa...
* postgres_dba alignment padding query 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 Postgres.fm to find audio-only podcast episodes, edited for convenient listening.
2 мар 2023