Search: "#Postgres"
Show posts from unknown users
crib.social is back from some system maintenance.
I've learned more about #postgres vacuuming too.
OTOH, it would be better if fediverse admins didn't have to do any maintenance on their database at all. Having to do so makes it much harder to self-host, and this in turn both reduces the size of... show more
Adding or dropping indexes 📒 in a live PostgreSQL database means locking the entire table, potentially causing application slowdowns or outages. Use CONCURRENTLY with CREATE INDEX or DROP INDEX to perform the operation in the background. #postgres
Fun story: when I was migrating my #Matrix database to a new version of #Postgres, some people were still able to chat since they had accounts on other servers. My account and my server's chatrooms were down, but it wasn't complete downtime for everyone.
This is what #decentralization looks like.... show more
Because why use MongoDB when you can just make Postgres look like MongoDB? 🤣 Companies finally getting it: Postgres does it all. 🐘 (It's open source, btw) #microsoft #postgres #mongodb #nosql github.com/microsoft/documentdb
Popular
Loading popular posts...