Phil Allsopp
Recent posts
By using a BRIN index instead of a BTREE index for certain queries, you can get huge index size savings with very similar performance.
I was asked recently where PostgreSQL actually stores its data on disk. So I thought I’d share this.
I noted there are many aspects of PostgreSQL crucial to the ongoing performance and availability of a database about which a Dev team may not be familiar.
Tired of constantly running checks on your PostgreSQL activity as it happens? Save time and energy with \watch.
