Transaction ID wraparound PostgreSQL uses 32-bit transaction IDs. This is a pretty large number (about 4 billion), but with intensive work of the server, this number…
View More The Transaction ID Wraparound and Freezing in PostgreSQL-8
Tag: tuples
AutoVacuum in PostgreSQL-7
We’ve already mentioned that normally (i. e., when nothing holds the transaction horizon for a long time) VACUUM usually does its job. The problem is how…
View More AutoVacuum in PostgreSQL-7
Vacuum in postgreSQL-6
What does vacuum do? In-page vacuum works fast, but frees only part of the space. It works within one table page and does not touch…
View More Vacuum in postgreSQL-6
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