Neues vom PostgreSQL Planet
Ahsan Hadi: PostgreSQL clustering solutions
Henrietta Dombrovskaya: PG Day Chicago – the talks I am most excited about (part I)
I am really excited about the PG Day Chicago schedule! As I mentioned multiple times, I am immensely grateful to our amazing program committee, especially to the committee chair, Karen Jex. Now, I want her to chair all our CfP committees (at least as long as I am in charge:)).
Mark Wong: PDXPUG April Meeting: What’s new in PostgreSQL 17
Please RSVP on Meetup https://www.meetup.com/pdxpug/events/300096141/ so we have an idea how many folks are attending!
Date: Thursday April 18th, 2024
Time: 6:30pm to 8:30pm US Pacific
Location:
American Red Cross
3131 N Vancouver Ave, Portland, OR 97227
Speaker: Mark Wong
Shaun M. Thomas: PG Phriday: A Dirty Postgres Rag
cary huang: Procedure To Multiple Client Certificate Feature
I shared a patch some time ago that adds a feature on libpq to allow user to supply multiple client certificate pairs. The feature is capable of choosing one client certificate to send to the server (if it requests one) based on the server’s trusted CA certificate settings during TLS handshake. Refer to this blog here that explains more on the principles of chains of trust.
David Wheeler: PGXN v2: Go or Rust?
TL;DR: I’d like Postgres community input on a decision: Should we build PGXN v2 services and tools in Go or Rust? Context for the question and some weighing of options constitutes the rest of this post, but to skip to the end, 🗳️ Vote your choice! Poll closes April 12 at the end of the day (midnight) New York time.
semab tariq: Build HNSW 80% Faster with Parallel Index Build in pgvector
Discover the latest in pgvector 0.6: Parallel Index Building for HNSW. Learn how this major update speeds up index creation in Postgres.
The post Build HNSW 80% Faster with Parallel Index Build in pgvector appeared first on Stormatics.
Elizabeth Garrett Christensen: Contributing to Postgres 101: A Beginner's Experience
I recently got my very first patch into PostgreSQL! To be clear I'm not a C developer and didn't contribute some fancy new feature. However, I do love Postgres and wanted to contribute. Here's my journey and what I learned along the way.
vignesh C: A day in the life of a Postgres engineer at Fujitsu - Vigneshwaran C
Postgres engineers at Fujitsu have been contributing to the community to enhance OSS PostgreSQL features for enterprise adoption, in the areas such as replication and performance. In this blog, I would like to give you a brief look on how I take on my day-to-day activities and what I am passionate about.
Kai Wagner: Enhancing PostgreSQL Insights with Percona Monitoring and Management: A Closer Look at Recent Updates
Gabriele Bartolini: CloudNativePG Recipe 5 - How to migrate your PostgreSQL database in Kubernetes with ~0 downtime from anywhere
Are you considering migrating your PostgreSQL database from a service provider into Kubernetes, but you cannot afford downtime? Recipe #5 details step-by-step instructions, leveraging CloudNativePG and logical replication, to seamlessly transition from PostgreSQL 10+ to 16 using an imperative method. Learn how to set up initial configurations, execute migrations, and handle various use cases, such as transitioning from DBaaS to Kubernetes-managed databases and performing version upgrades.
Adam Hendel: Building a Managed Postgres Service in Rust: Part 1
Tembo was founded in December 2022 with a mission to make the best Postgres service to deploy extensions. That mission has evolved since then to provide optimized Postgres instances for your workload, but let’s go back to the start. At the very minimum, we wanted our users to be able to come to Tembo Cloud, create a new Postgres instance, install Postgres extensions into that instance, and connect to that Postgres instance over the public internet.
Kaarel Moppel: Best pg_basebackup compression settings for v15 and above
Christoph Berg: Recovering Deleted Data From PostgreSQL Tables
PostgreSQL is very good at keeping your data safe so it doesn’t disappear by itself. Unfortunately, the same holds in reverse–if data has been deleted, it stays unrecoverable.
In this article, we’ll explore options for recovering deleted data from PostgreSQL tables.
If you never make any mistakes when working with data, there won’t be any need for emergency procedures. But since we are all human, things like this happen:
David Wheeler: Mini Summit Two
We had such thoughtful and engaged discussion at this week’s Postgres Extension Ecosystem Mini-Summit! I did learn that one has to reserve a spot for each mini-summit individually, however. Eventbrite sends reminders for each one you sign up for, not all of them.
Christophe Pettus: Checking Your Privileges
The PostgreSQL roles and privileges system can be full of surprises.
Let’s say we have a database test, owned by user owner. In it, we create a very secret function f that we do not want just anyone to be able to execute:
Ryan Booz: PostgreSQL CFP PASS Data Community Summit
Andreas 'ads' Scherbaum: Grant Fritchey
cary huang: Understand PostgreSQL’s Planner – Simple Scan Paths vs Plans
When you send a query to PostgreSQL, it normally would go through stages of query processing and return you the results at the end. These stages are known as: