Neues vom PostgreSQL Planet
Robert Haas: Hacking on PostgreSQL is Really Hard
Hacking on PostgreSQL is really hard. I think a lot of people would agree with this statement, not all for the same reasons. Some might point to the character of discourse on the mailing list, others to the shortage of patch reviewers, and others still to the difficulty of getting the attention of a committer, or of feeling like a hostage to some committer's whimsy.
Jobin Augustine: LDAP Authentication in PgBouncer Through PAM
David Wheeler: Mini Summit: Universally Buildable Extensions
Well that snuck up on me. Tomorrow, May 1 2024, Yurii Rashkovskii of Omnigres will be giving a presentation at the fifth installment of the Postgres extension ecosystem mini-summit. The tal, “Universally buildable extensions: dev to prod”, should provoke some interesting asymmetrical thinking and discussion.
muhammad ali: Logging Basics for PostgreSQL
Explore foundational parameters for maximizing the utility of PostgreSQL logs.
The post Logging Basics for PostgreSQL appeared first on Stormatics.
Jonathan Katz: The 150x pgvector speedup: a year-in-review
I wanted to write a “year-in-review” covering all the performance pgvector has made (with significant credit to Andrew Kane), highlighting specific areas where pgvector has improved (including one 150x improvement!) and areas where we can continue to do better.
Henrietta Dombrovskaya: Hey Chicago – We did it!!!
The PG Day Chicago 2024 is over. For the last two days, I have been reading my LinkedIn and X feeds, which are full of mentions of PG Day Chicago. Everyone is happy and thankful.
Although I am busy “liking” all of these posts—not just “liking” but truly liking them—I didn’t blog anything myself. Two days later, I finally organized my thoughts to talk about that event.
Peter Eisentraut: PostgreSQL supported platforms over time
The recent discussion about AIX support in PostgreSQL (as of now removed in PostgreSQL 17) led me to look through the project’s history, to learn what platforms we have supported when.
Andreas Scherbaum: Hamburg PostgreSQL Meetup in April 2024
On April 23rd - after a very long break - the third PostgreSQL Meetup took place in Hamburg.
Sascha had temporarily taken over the Meetup group after the previous admins were no longer available. Last year at PGConf.DE 2023 I asked if there is anyone interested who would like to revive the group. Tobias had agreed to do so, and Lenz also joined the effort at the PGConf.EU 2023. After a few organizational details, the first (or rather third) meetup was scheduled.
Robins Tharakan: Boost Database Security: Restrict Users to Read Replicas
Radim Marek: The Bloat Busters: pg_repack vs pg_squeeze
As the database size increases and the number of transactions per second rise, you'll inevitably face the challenge of the table bloat. Although PostgreSQL assists as much as possible with its auto-vacuum feature, there will come a time when you will compel whether to run VACUUM FULL. Unless you have option of longish downtime windows, this is not an easy decision.
Shaun M. Thomas: PG Phriday: Papa's Got a Brand New RAG
Pavel Borisov: Postgres Bloat Minimization
David Wheeler: Mini Summit Four
My thanks to Jonathan Katz for his presentation, “Trusted Language Extensions for PostgreSQL”, at last week’s Postgres Extension Ecosystem Mini-Summit. As usual I’ve collected the transcript here interspersed with comments from the chat window. First, links!
Julian Markwort: Patroni Contributors Meeting 2024 in Munich
The day before pgconf.de 2024 in Munich, a few of the Patroni project's contributors met to discuss the past, present and future of this framework for PostgreSQL HA. Various people and companies support and benefit from Patroni. Ants Aasma and I attended the meeting on behalf of CYBERTEC.
Umair Shahid: 7 considerations for PCI DSS compliance in PostgreSQL
Learn how to ensure PCI DSS compliance in your PostgreSQL database with these 7 crucial considerations.
The post 7 considerations for PCI DSS compliance in PostgreSQL appeared first on Stormatics.
David Wheeler: Test and Release pgrx Extensions with pgxn-tools
Yesterday I released v1.6.0 of the pgxn/pgxn-tools Docker image with a new command: pgrx-build-test works much like the existing pg-build-test utility for PGXS extensions, but for pgrx extensions.
Ashutosh Bapat: PostgreSQL's memory allocations
There's a thread on hackers about recovering memory consumed by paths. A reference count is maintained in each path. Once paths are created for all the upper level relations that a given relation participates in, any unused paths, for which reference count is 0, are freed. This adds extra code and CPU cycles to traverse the paths, maintain reference counts and free the paths. Yet, the patch did not show any performance degradation.
Avi Vallarapu: Announcing PGDSAT to satisfy CIS benchmarks for PostgreSQL
In an era where data breaches are both costly and damaging to reputations, implementing best practices and robust security measures is crucial. PostgreSQL has emerged as one of the most successful and highly adopted open-source databases, competing with the enterprise standards of Oracle and SQL Server. Its increasing popularity is evident from DBEngine rankings, Stackoverflow […]
David Wheeler: PGXN V2 Architecture
High-level diagram of the six logical services making up the proposed future extension distribution architecture. The Root Registry sits at the center, providing APIs for the other services to consume for their own use cases. Trusted instances of those services submit additional data about extensions via the Interactions service to enhance and enrich the service to better inform and delight users.