Powered by Percona Server for PostgreSQL and pgvector
When I started learning tennis as an adult, I realized that what made tennis difficult was not learning the tennis strokes, instead it was learning to realize t...
September 10 #PMM #Query Optimization #Community
A database migration can be syntactically correct and still be a poor release candidate. A regular index build can block writes, an ALTER TABLE may wait behind ...
September 8 #PostgreSQL #Migrations #CI #Testing
When setting up a new database for an application, high availability (HA) is one of the main priorities. Let’s assume for this example that you chose to use a P...
September 7 #MySQL #ProxySQL #Opensource #BGP
When activity spreads across GitHub, the forum, and content, real contribution is easy to lose in the noise. A community program only works when people trust th...
August 31 #Community #Percona #Open Source #Mountaineers
Two recent posts on the Percona blog caught my attention. In Replicating from InnoDB into a DuckDB storage engine and The DuckDB MySQL engine at 500 GB, Evgeniy...
August 26 #MySQL #DuckDB #Parquet #Opensource
Back in February, I wrote about Hackorum, a forum style web view of the pg-hackers mailing list. If you missed that post, you can read it here first. It turns t...
August 20 #Percona #PostgreSQL #Community #Mailing Lists
I would like to introduce here the curious case that I had on a Patroni Cluster in production, after a migration from Oracle, with timezone differences between ...
August 20 #PostgreSQL #Patroni #PgBouncer #Kubernetes
Every great journey needs a guide....
August 6 #Community #Percona #Events #Remote Work
Over the years working on various MongoDB troubleshooting cases, I’ve been wondering how to handle the longish JSON outputs from the most common diagnostic comm...
July 27 #MongoDB #Opensource #DBA #GUI
What’s the impact of TDE on performance? People usually quickly throw together a few graphs with basic measurements and treat that as a complete answer, but the...
July 20 #PostgreSQL #Opensource #pg_zsolt #TDE
On July 9–10, the two of us - Sandra (Engineering, Percona for MongoDB) and Radek (Product, Percona for MongoDB) - packed our backpacks and headed to Berlin for...
July 17 #Events #Community #Open Source #AI
You filed a bug report at 11pm because you’d already done the work to isolate it. You answered a forum question that had been sitting unanswered for three days....
July 16 #Community #Percona #Open Source #Mountaineers
Recently we noticed a LinkedIn post promoting open_pg_tde, a fork of our pg_tde, claiming to be more open. I looked at the repository, and have to disagree with...
July 8 #PostgreSQL #Opensource #pg_zsolt #TDE
A MySQL InnoDB Cluster provides high availability for a single database cluster using Group Replication. This works well for node failures inside the cluster, b...
July 6 #Percona #Kubernetes #Cloud #Community
Vacuum, or more precisely autovacuum, is the most important automatic maintenance task in PostgreSQL. It is key for performance, but also for long-term database...
July 1 #PostgreSQL #autovacuum #vacuum #mvcc