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: toast
Snapshot Isolation and Multi Version Concurrency Control in PostgreSQL-2
Relations If you look inside tables and indexes, it turns out that they are organized in a similar way. Both are database objects that contain…
View More Snapshot Isolation and Multi Version Concurrency Control in PostgreSQL-2