What is the TOAST ? Have you ever wondered how Postgres stores rows that exceed the size of a block? As a reminder, the default…
View More TOAST compression and toast_tuple_targetTag: lz4
LZ4 TOAST compression in PostgreSQL 14
Background In PostgreSQL, a page is the basic unit to store data, and the size of each page is 8 kB by default. Basically, data in one…
View More LZ4 TOAST compression in PostgreSQL 14