Rules or triggers to log bulk updates?
by
Laurenz Albe |
07.2018 Inspired by my co-worker's recent blog post, I decided to revisit the old question of rules vs. triggers and […]
Adding an index can decrease SELECT performance
by
Laurenz Albe |
06.2018 We all know that you have to pay a price for a new index you create — data modifying […]
In a recent wrestling match with the Linux “out-of-memory killer” for a CYBERTEC customer I got acquainted with Linux […]
Avoiding “OR” for better query performance
by
Laurenz Albe |
05.2018 PostgreSQL query tuning is our daily bread at CYBERTEC, and once you have done some of that, you'll start […]
xmax is a PostgreSQL system column that is used to implement Multiversion Concurrency Control (MVCC). The documentation is somewhat terse: […]
Why should I get rid of unused indexes? Everybody knows that a database index is a good thing because it […]
Four reasons why VACUUM won't remove dead rows from a table
by
Laurenz Albe |
03.2018Why vacuum? Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid […]
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” […]
How a bad network configuration can cause table bloat
by
Laurenz Albe |
01.2018(Updated 2023-04-20) I recently had an interesting support case with table bloat that shows how the cause of a problem […]
