Neues vom PostgreSQL Planet
David Wheeler: RFC: PGXN Meta Spec v2
Two bits of news on the “PGXN v2” project.
Daniel Vérité: Implementing UUIDs v7 in pure SQL
Tomas Vondra: Autovacuum Tuning Basics
A few weeks ago I covered the basics of tuning checkpoints, and in that post I also mentioned autovacuum as the second common source of performance issues (based on what we see on the mailing list and at our customers). Let me follow-up on that with this post about how to tune autovacuum, to minimize the risk of performance issues. In this post I'll briefly explain why we even need autovacuum (dead rows, bloat and how autovacuum deals with it), and then move to the main focus of this blog post - tuning.
Andreas 'ads' Scherbaum: Ozgun Erdogan
Andrei Lepikhov: How expensive is it to maintain extended statistics?
In the previous post, I passionately advocated for integrating extended statistics and, moreover, creating them automatically. But what if it is too computationally demanding to keep statistics fresh?
This time, I will roll up my sleeves, get into the nitty-gritty and shed light on the burden extended statistics put on the digital shoulders of the database instance. Let's set aside the cost of using this type of statistics during planning and focus on one aspect - how much time we will spend in an ANALYZE command execution.
Shayon Mukherjee: Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL
Andrew Atkinson: SaaS on Rails on PostgreSQL — POSETTE 2024
In this talk attendees will learn how Ruby on Rails and PostgreSQL can be used to create scalable SaaS applications, focusing on schema and query design, and leveraging database capabilities.
We’ll define SaaS concepts, B2B, B2C, and multi-tenancy. Although Rails doesn’t natively support SaaS or multi-tenancy, solutions like Bullet Train and Jumpstart Rails can be used for common SaaS needs.
Christophe Pettus: Checking Your Privileges, 2
I turned the last blog post into a talk; you can get the slides here.
Umair Shahid: Guide to Auditing and Monitoring Access in PostgreSQL
In the data-driven world of today, maintaining the security and integrity of your database is paramount. Auditing and monitoring access to your database are critical components of an effective security strategy. These processes help ensure that only authorized users are accessing sensitive information and that any unauthorized access attempts are detected and addressed promptly.
Robert Haas: Mentoring Program Updates
Here are a few updates on the mentoring program that I announced in a previous blog post.
Gabriele Bartolini: CloudNativePG Recipe 9 - Inspecting the network and the storage in a CloudNativePG cluster
In this blog post, I delve into the crucial aspects of networking and storage within a CloudNativePG cluster deployed on Kubernetes. I explore how Kubernetes services manage external and internal communications for PostgreSQL clusters, ensuring high availability and seamless failover. Additionally, I examine the role of PersistentVolumeClaims in handling PostgreSQL data storage, offering insights into effective resource management.
Hans-Juergen Schoenig: Using AI to generate data structures for PostgreSQL
Artificial Intelligence is the motto of the day. Everybody is talking about it, everybody seems to know what it means and the insane number of buzzwords floating around on the internet is just mind-boggling. It seems that in some areas of the industry, the number of slides and marketing videos exceeds the number of real-world use cases and sometimes even the amount of code that actually exists.
Claire Giordano: Say hello to the Talking Postgres podcast
The TL;DR of this blog post is simple: the “Path To Citus Con” podcast for developers who love Postgres has been renamed—and the new name is Talking Postgres.
And if you’re just hearing about the Talking Postgres podcast for the first time, it is a monthly podcast for developers who love Postgres, with amazing guests from the Postgres world who talk about the human side of Postgres, databases, and open source.
Sergey Pronin: Automated Major Version Upgrades in Percona Operator for PostgreSQL
Umair Shahid: Access Controls in PostgreSQL
Secure your PostgreSQL database with effective access control. Learn role management, privileges, and Row-Level Security (RLS) techniques.
The post Access Controls in PostgreSQL appeared first on Stormatics.
Andreas 'ads' Scherbaum: Grant Zhou
Tomas Vondra: Basics of Tuning Checkpoints
Elizabeth Garrett Christensen: Parallel Queries in Postgres
Many folks are surprised to hear that Postgres has parallel queries out of the box. This was released in small batches across a half dozen versions of Postgres, so the major fanfare for having parallelism got a little bit lost.
Andrei Lepikhov: Why PostgreSQL prefers MergeJoin to HashJoin?
Today's post is sparked by a puzzling observation: users, especially those who use an abstraction layer like REST or ORM library to interact with databases, frequently disable the MergeJoin option across the entire database instance. They justify this action by citing numerous instances of performance degradation.