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...
TOAST wiki wiki.postgresq...
Hussein Nasser on rows per page (Twitter) / 1627876515491766273
Toasting in action (dbi services blog) www.dbi-servic...
Interview with Peter Zaitsev (Postgres TV) • Interview: Peter Zaits...
Building columnar compression in a row-oriented database (Timescale blog post) www.timescale....
The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (blog post by Haki Benita) hakibenita.com...
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/Nik...
-------------
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.
Негізгі бет Ойын-сауық TOAST | Postgres.FM 035 |
Пікірлер: 5