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.
Sur cette page du site, vous pouvez voir la vidéo en ligne TOAST | Postgres.FM 035 | durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur PostgresTV 💙💛 03 mars 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 843 fois et il a aimé 26 téléspectateurs. Bon visionnage!
