VirtualBox vs. hardware for PostgreSQL
Is there really a performance difference in PostgreSQL on hardware and PostgreSQL on Virtualbox? Find out here.
pg_service.conf: The forgotten config file
Configure services in a config file: pg_service.conf, and address them without having to worry about host, port, user and so on.
Permissions: A little trickery
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.
Managing backup speed with pg_basebackup
How to adjust backup speed when using pg_basebackup in PostgreSQL. What if the I/O capacity of servers is low & network bandwidth is large?
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.
pg_resetxlog: renamed to pg_resetwal
pg_resetxlog was formerly a feature of PostgreSQL. This has been renamed to pg_resetwal, see the update in the blog.
wal_level: What is the difference?
PostgreSQL replication requires changing the wal_level from “minimal” to “hot_standby”. What er the impacts? Read out more.
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.
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.
PostgreSQL shutdown modes
PostgreSQL has three shutdown modes - smart, fast, immediate. Check out this blogpost to learn more about all of them.
