#postgres
So, es ist soweit, ich suche einen Managed #Kubernetes Anbieter in #Österreich oder sonst wo in der #EU. Google hab ich schon bedient, aber wenn jemand persönlich gute Erfahrung mit einem Anbieter hat, würde mir das weiterhelfen. Managed #Postgres und #Kafka dabei gibt Pluspunkte ;)
Gerne Retoot.
We made Postgres writes faster, but it broke replication
Link: https://www.paradedb.com/blog/lsm_trees_in_postgres
Discussion: https://news.ycombinator.com/item?id=44633933
We're always looking for speakers for our virtual Meetups! Got something to share? We'd love to hear from you! Drop us a DM on Meetup and you could be our next speaker!
AWS open-sourced Postgres active-active replication extension
Link: https://github.com/aws/pgactive
Discussion: https://news.ycombinator.com/item?id=44580257
How are people here running #postgres in #highavailability mode when #selfhosting?
I've used #MySQL before (last time was 2016, I think), but today I'm mostly onto #Postgres (and sometimes, #SQLite). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.
What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?
It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)
When Sigterm Does Nothing: A Postgres Mystery
Link: https://clickhouse.com/blog/sigterm-postgres-mystery
Discussion: https://news.ycombinator.com/item?id=44567888
Je vais faire un article de blog sur le sujet mais je pense que c'est principalement du à la désactivation du nettoyage (vaccum) auto de la base postgres:
La suppression d'une entrée dans une base postgres n'entraîne pas la supppression réelle de la donnée sur le disque. Ce processus n'est effectuée qu'après X suppressions de données.
Le soucis c'est qu'il est très coûteux et la façon dont est codé Pleroma/Akkoma produit bcp de suppressions donc bcp de vaccum.
La base est donc continuellement busy à cause de ce processus, empêchant de répondre correctement aux requêtes des utilisateurs.
Ce que j'ai fait ici c'est de complètement désactiver ce processus, qui tourne maintenant une seule et unique fois chaque nuit, quand le serveur est down pour sauvegarde.
Je pense que j'aurai pu tweak les paramètres pour juste faire moins d'auto vacuum mais on aurait quand même eu le soucis assez régulièrement de requêtes qui prennent des plombes à cause de ça
Je pense qu'en l'état c'est un système satisfaisant !
#postgres #akkoma
Install and run a PostgreSQL database locally on Linux, MacOS or Windows. PostgreSQL can be bundled with your application, or downloaded on demand.
This library provides an embedded-like experience for PostgreSQL similar to what you would have with SQLite.
*Takes a deep breath*
#MariaDB might be the best general database engine ever and it sucks that the for-profit company using the name kept stepping on rusty rakes over and over again so that people in suits who can't distinguish the corp from the foundation pushed for other platforms.
Side note: #PostgreSQL, I want to love you, but I have so many similar feelings about you as I do about coding in rust. You're too pedantic for your own good.
In testing a postgres upgrade (13->15) for our mastodon-servcer, I run into a fatal error 'Your installation contains user-defined objects that refer tointernal polymorphic functions with arguments of type "anyarray" or "anyelement". Haven't been able to find a fix for this online, and there seems to be no logfile to pinpoint the cause. Anyone have any suggestions on how to fix this? #techquestion #mastoadmin #postgres [Edit: solved, see reply]
Postgres LISTEN/NOTIFY does not scale
Link: https://www.recall.ai/blog/postgres-listen-notify-does-not-scale
Discussion: https://news.ycombinator.com/item?id=44490510
On Wed Jul 9 at 10am PDT, we're doing a LIVE recording of Ep29 of the #TalkingPostgres #podcast 
with guest Shireesh Thota—to talk about how he got started leading database teams.
Join us on Discord to be part of the parallel live text chat. Cal invite with instructions on how to join the Discord: https://aka.ms/TalkingPostgres-Ep29-cal
#PostgreSQL #community #opensource #Microsoft #Azure #Postgres
As always, boosts appreciated 
Dear #Fediverse, I need your recommendation:
I'm building a #website that in the end consists of a #Docker #NodeJS image/container and a #Postgres container. What options are there to host those containers on the #Web? I'm looking for a cheap or even free (?!) solution. I expect less than 50 users, so big hardware or scalability is not an issue. Would a virtual server with #minikube be a viable option? I'm a Docker and #Kubernetes newb so please bear with me.
Nexus joins data across systems and you can process the join anywhere.
https://coffingdw.com/1000-techniques-to-join-data-across-systems/
Nexus can join one hundred tables from one hundred different systems in a single query.
https://coffingdw.com/2023-a-100-table-join-across-100-systems/
Nexus builds a visualization dashboard for every user on every system for every answer set.
Join data across clouds in a single query as easily as if all tables were on a single system.
Have you seen the syntax of INNER JOIN? Of course! What about NATURAL INNER JOIN?
https://coffingdw.com/new-to-sql-is-the-keyword-natural-join/