TOAST | Postgres.FM 035 |
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 ...
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.
On this page of the site you can watch the video online TOAST | Postgres.FM 035 | with a duration of hours minute second in good quality, which was uploaded by the user PostgresTV 💙💛 03 March 2023, share the link with friends and acquaintances, this video has already been watched 843 times on youtube and it was liked by 26 viewers. Enjoy your viewing!
