Logging - the hidden speedbrakes
When it comes to performance, people tend to forget some basic topics entirely. One of those topics is the impact of writing log files.
max_connections - Performance impacts
Setting max_connections to an insanely high value is not good for performance. I tried it, to see what impact it has in PostgreSQL.
Adjusting maintenance_work_mem
After testing shared_buffers recently, I decided to do a little more testing on our new office desktop PC (8 core […]
PostgreSQL 9.3 - Shared Buffers Performance (1)
A lot has been said about PostgreSQL shared buffers and performance. As my new desktop box has arrived this week […]
Detecting fraud: Benford's law
Benford's law is a mechanism, which is widely used in many fields. Especially accounting fraud can be detected nicely using this simple law of mathematics.
Fed up with long WHERE-clauses?
What if you want to compare dozens of columns with each other in PostgreSQL? Find out how to do it right here.
PostgreSQL shutdown modes
PostgreSQL has three shutdown modes - smart, fast, immediate. Check out this blogpost to learn more about all of them.
Tracking changes in PostgreSQL
UPDATED 2023 - How to track changes made to tables in PostgreSQL - instructions how to use a generic changelog trigger for tracking changes.
Making random() deterministic - random generator in PostgreSQL
How to reproduce a random sequence of numbers. Reset the random generator to restart a certain value in PostgreSQL. random()
Security barriers: Cheating on the planner
UPDATED Aug. 2023 - How a security barrier can theoretically be used to speed up PostgreSQL queries and to see how PG works under the hood.
