Tootfinder

Finally took the time VACUUM FULL all my #PostgreSQL #databases and empty a runaway table. Dropped from ~90% diskusage to ~25% and a hell of a lot less CPU

FWIW, dropped my #Mastodon #postGreSQL #database from 19.5GB down to 5.3GB

Why is #postgresql so anal about backup versions?
Did the devs forget that backups are only helpful if you can restore them?

#PgBouncer is useful, important, and fraught with peril
https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html

Today I learned a nice #PostgreSQL snippet to generate a random timestamp: `select now()::date (random() * interval '1 day');`

Thanks to @…, I've deleted my toot on #PostgreSQL 18 since after verification, it claimed "unverified" capabilities.
…