Episode 28 of 5Mins of Postgres by pganalyze.

Check it out at: https://www.youtube.com/watch?v=4RNCsJ_xMIE

pgAdmin 4 v6.12 Released

You can get the latest release at: https://www.pgadmin.org/download/

Good Article about Autovacuum by citusdata

Check it out at: https://www.citusdata.com/blog/2022/07/28/debugging-postgres-autovacuum-problems-13-tips/

My Learnings

A couple of the systems I support want to use partitioning for data management and I spent some time reading the docs. Interesting stuff. I will being playing around with this on my local instances to test it out.

My Frustrations

One of the systems I support is generating thousands of errors per minute trying to stuff too large of a number into a SMALLINT column. Somehow this is my fault… I suggested that they validate the data and send a meaningful message back to the caller rather than relying on the database to reject it, but you know how well coding advice from a DBA is appreciated.