Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)
https://www.recall.ai/blog/postgres-postmaster-does-not-scale
(Geht im Post primär um #PostgresSQL)
Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.
When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.
It is not that the other DBs are bad. I find Postgres better.
Does anybody know if Postgres added more strict query argument checking since PG14?
I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)
Whew.
Finally back online with a spankin' new Mastodon instance.
Still, same address and .. the same ole Alex.
I spent days trying to update #Mastodon 4.4.8 to 4.5.0 but something was wrong...very wrong.
I think it was a database corruption but #PostgresSQL and I aren't really pals, so rebuild was the "easy" way out.
That old instance had been running, more or less without problems, since late 2022. So maybe it was time. But still, I wonder why the update from 4.4.8 broke it.
PostgreSQL permissions are driving me up the wall.
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;
This only appears to apply to existing tables and needs to be run again after any new tables created.
Anybody know a way to have it apply at the SCHEMA level including new tables?
身為工程師兼DJ，把文件中的 #PostgresSQL 看成 #ProgressiveSQL 是很正常的事....
Moje subiektywne zapiski z kursu...
https://blog.jurkiewicz.tech/kurs-administracji-postgresql-zapiski-9239f6838bb4
#PostgresSQL #kurs #blog #linux
I want to move my #Postgres database from the VPS that Mastodon is on.
I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.
Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin
It's the Steller Plus plan at NameCheap
EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.
alios
looopTools
Ben Hardill
Alex Neihaus
Abbygail ET Wu 吳伊婷 🇹🇼 🏳️⚧️
Jonas
Kingsley Uyi Idehen
Adam Jurkiewicz
Paul Chambers🚧