Djoerd Hiemstra 🍉
boosted
RegreSQL: Regression Testing for PostgreSQL Queries
https://boringsql.com/posts/regresql-testing-queries/
#HackerNews #RegreSQL #PostgreSQL #RegressionTesting #DatabaseTesting #SoftwareDevelopment
A question for the #MastoAdmin community:
What's your PostgreSQL backup strategy?
How much data would you expect to lose if your primary DB died suddenly?
Seconds? Hours? Days?
Pascal
boosted
News includes ReqLLM 1.0 with standardized LLM APIs, Codicil bringing semantic code understanding to #AI assistants, Tidewave Web expanding to #Python and more, playwright browser pooling, and #PostgreSQL WAL for DB notifications! @elixirlang #ElixirLang https://www.youtube.com/watch?v=tXp8hchfuh0
News includes ReqLLM 1.0 with standardized LLM APIs, Codicil bringing semantic code understanding to #AI assistants, Tidewave Web expanding to #Python and more, playwright browser pooling, and #PostgreSQL WAL for DB notifications! @elixirlang #ElixirLang https://www.youtube.com/watch?v=tXp8hchfuh0
#PostgreSQL 8.1 was released 20 years ago.
New features include: 2 phase commit (comes in handy for distributed and sharded databases), the role system (previously users and groups) and finally Autovacuum became part of the server.
And hopefully no version 8.1 is out there still in production!
@jimsalter @joeress here's one for your 2.5 admins. #25admins #zfs #postgresql
https://matrix.org/blog/2025/10/post-mortem/ great write-up and #HugOps to those involved over that very stressful period.
- it's great to see they had a comprehensive backup/recovery strategy in place
- well done, really well done. Multiple fallback layers. Sad that they had to use them, but hey that's why we do this.
- Kudos to @beasts hosting for moral & technical support, once again I keep hearing good things about them
A story in SQL backup/recovery from matrix.org with three key lessons:
- always do critical recovery work with 2+ people checking and reviewing together (they did this), and rotate regions because sleep is critical
- never actually delete stuff during a crisis. Ever (narrator: they learned this the hard way)
- ZFS would have made this recovery significantly easier, in so many ways
It would have been almost trivial to recover from their failed storage with ZFS, and perhaps avoid either the failover, or the remote restore.
Scheduled ZFS snapshots would have meant a rollback instead of a recover in at least 2 of their high-risk moments.
It would have also meant higher storage costs because snapshots are almost but not quite free.
ZFS snapshots can be sent/received from an alternate system, over LAN at very high rates, much much faster than a remote S3-based streaming restore.
Tried to upgrade #postgresql for my oldfriends.live #Mastodon ( @paul ) instance from 13 to 18 and got incompatible_polymorphics errors following @michael guide. Can anyone offer advice?
The error is:
In database: postgres
aggregate: repack.array_accum(anyelement)
In database: mastodon_production
aggregate: repack.array_accum(anyelement)
Andres Freund getting ready to tell us everything we need to know to use asynchronous I/O (AIO) with PostgreSQL 18 and beyond
Luc, framage
boosted
We are excited to welcome LOXODATA as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.
We are excited to welcome LOXODATA as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.
Jeremy ⁂
boosted
PG Lord of the Ring | My DBA Notebook https://mydbanotebook.org/posts/pg-lord-of-the-ring/ #postgresql
PG Lord of the Ring | My DBA Notebook https://mydbanotebook.org/posts/pg-lord-of-the-ring/ #postgresql
phildini
boosted
What if Django had an automatic ORM feature matrix — showing which features each database really supports, straight from the code? 🧩
I’ve shared some ideas (with demo data!) on how it could work and why it’d be great for Django’s docs 💡
https://www.paulox.net/2025/10/06/django-orm-comparison/
CC @django
#Django #Python #ORM #OpenSource #Database #PostgreSQL #SQLite #MariaDB #MySQL
What if Django had an automatic ORM feature matrix — showing which features each database really supports, straight from the code? 🧩
I’ve shared some ideas (with demo data!) on how it could work and why it’d be great for Django’s docs 💡
https://www.paulox.net/2025/10/06/django-orm-comparison/
CC @django
#Django #Python #ORM #OpenSource #Database #PostgreSQL #SQLite #MariaDB #MySQL
deutrino
boosted
Stefano Marinelli
boosted
Reflection on PGDay UK 2025 💬✨
We had a fantastic time connecting with the PostgreSQL community and diving deep into performance tuning.
Read more about our impressions to this event:
https://www.credativ.de/en/blog/events-en/pgday-uk-2025/
#credativ #PGDayUK2025 #PostgreSQL #OpenSource #DatabaseCommunity
