Jul 07, 2022 |
Insight for DBAs, PostgreSQL
Replication sits at the core of database high availability (HA). While on-disk data can be replicated through various methods, whether hardware or software, disk, file, or block-based solutions, without an online copy of the database, HA setup cannot be achieved. This blog digs into more detail the challenges/conflicts that impact PostgreSQL replication, but before we […]
Apr 19, 2022 |
Insight for DBAs, PostgreSQL
Concurrent access to data within PostgreSQL is managed with the Multiversion Concurrency Control (MVCC) model. Data snapshots are maintained for each SQL statement so that they always get consistent data, even if other transactions are modifying it concurrently. This leads to managing multiple versions of the same row when the row has been modified by […]
Jul 30, 2021 |
Insight for DBAs, Monitoring, Percona Software, PostgreSQL
Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well. PostgreSQL provides very detailed statistics through a number of catalog views and extensions that can be easily added to provide more […]