Using High Availability is a requirement for companies all over the world. Streaming replication allows a standby server to stay more up-to-date than is possible…
View More PostgreSQL 14 Streaming Replication (Sync / Async) on CentOS 7
Tag: postgres
Replication Slots in PostgreSQL ?
What are WAL Files? Write-Ahead Log (WAL) is a record of the changes made to the data. It ensures that when there is a crash…
View More Replication Slots in PostgreSQL ?
Postgresql-14 Installation on Centos 7
yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
View More Postgresql-14 Installation on Centos 7
Integrate LDAP with local users in PostgreSQL
You want to allow LDAP users can use their passwords in login but you don’t want to create non-person accounts like application users in LDAP.…
View More Integrate LDAP with local users in PostgreSQL
The Transaction ID Wraparound and Freezing in PostgreSQL-8
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
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
In-page Vacuum & HOT Updates in PostgreSQL-5
In-page vacuum during regular updates When accessing a page for either an update or read, if PostgreSQL understands that the page is running out of…
View More In-page Vacuum & HOT Updates in PostgreSQL-5
How Consistent Data Snapshots Obtained from Tuples in PostgreSQL-4
What is a data snapshot? Data pages can physically contain several versions of the same row. But each transaction must see only one (or none)…
View More How Consistent Data Snapshots Obtained from Tuples in PostgreSQL-4
Row Versions in PostgreSQL-3
Tuple header As already mentioned, several versions of each row can be simultaneously available in the database. And we need to somehow distinguish one version…
View More Row Versions in PostgreSQL-3