Be prepared for prepared transactions
by
Laurenz Albe |
12.2018Prepared transactions are disabled in PostgreSQL by default, since the parameter max_prepared_transactions has the default value 0. You don't need […]
xmax is a PostgreSQL system column that is used to implement Multiversion Concurrency Control (MVCC). The documentation is somewhat terse: […]
idle_in_transaction_session_timeout: Terminating idle transactions in PostgreSQL
Long PostgreSQL transactions can cause table bloat. idle_in_transaction_session_timeout limits the duration of a transaction to prevent bloat
Improving transaction latency by moving indexes to faster media
To improve PostgreSQL transaction latency for OLTP systems a good trick is to move indexes of busy tables to fast SSD media.
New features for sequences: gains and pitfalls
by
Laurenz Albe |
02.2018About sequences Sequences are used to generate artificial numeric primary key columns for tables. A sequence provides a “new ID” […]
walbouncer: Filtering the transaction log
You might not want to replicate all data to your standbys. walbouncer can filter the transaction log, & replicate only the data needed.
Bypassing the transaction log
When data is changed generally the change must be written to the xlog before it is written to the underlying table.
Transactional DDLs – a message to non-PostgreSQL users
In this blog we will talk about transactional DDL's in PostgreSQL vs other database systems. Find out more information.
