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 […]
Monitoring cluster performance in PostgreSQL
How to monitor PostgreSQL database cluster performance with pg_stat_statements. Inspect an entire database cluster or a set of servers.
More on Postgres trigger performance
A performance test on more complex Postgres trigger usage scenarios, together with some extra info on trigger capabilities.
Are triggers really that slow in Postgres?
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
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 […]
Why should I get rid of unused indexes? Everybody knows that a database index is a good thing because it […]
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.
What PostgreSQL Full-Text-Search has to do with VACUUM
What does PostgreSQL Full-Text-Search have to do with VACUUM? Find out about the GIN pending list and how to use it to improve performance.
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” […]
