By using a BRIN index instead of a BTREE index for certain queries, I can get huge index size savings with very similar performance.
I was recently asked where PostgreSQL actually stores data on disk. So it's time to share this...
Knowing the difference between Developer skills and Support skills is crucial when faced with mission-critical situations.
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.
Keeping a step ahead of data thieves is an ongoing battle. Thankfully we have an impressive weapon on our side – encrypted tablespaces.