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.
Protecting clients' data has long been an immediate concern of mine as it probably is for you. Which is why I'm excited by Data Masking (also known as Data Redaction).
Keeping a step ahead of data thieves is an ongoing battle. Thankfully we have an impressive weapon on our side – encrypted tablespaces.
