Neues vom PostgreSQL Planet
Paolo Melchiorre: Posette 2024
An Event for Postgres (pronounced /Pō-zet/, and formerly called Citus Con) is a free and virtual developer event. The name POSETTE stands for Postgres Open Source Ecosystem Talks Training & Education.
Laurenz Albe: cursor_tuple_fraction and the PostgreSQL JDBC driver
This article is a kind of failure story. I originally set out to write a piece about the PostgreSQL parameter cursor_tuple_fraction, only to discover that my boss has already covered that topic to some extent. Then I thought that I could investigate the parameter’s effect on the JDBC driver. That led me to an embarrassingly long wrestle with auto_explain and an eventual failure to find anything. But the world is littered with success stories, so why not share some failure?
Andreas 'ads' Scherbaum: Nazir Bilal Yavuz
Brandur Leach: The Notifier Pattern for Applications That Use Postgres
Listen/notify in Postgres is an incredible feature that makes itself useful in all kinds of situations. I’ve been using it a long time, started taking it for granted long ago, and was somewhat shocked recently looking into MySQL and SQLite to learn that even in 2024, no equivalent exists.
Henrietta Dombrovskaya:
At PG Day Chicago, I presented an extended version of my talk given last year at Citus.con – Temporal Tables and Standard. Just between the time my talk was accepted and I delivered the presentation, I learned that PG 17 would include the first-ever support of an important temporal feature: uni-temporal primary keys and unique constraints.
gabrielle roth: LinuxFest Northwest PostgreSQL Booth Report
Radim Marek: How not to change PostgreSQL column type
One of the surprises that comes with developing applications and operating a database cluster behind them is the discrepancy between practice and theory, development environment and the production. A perfect example of such a mismatch is changing a column type.
The conventional knowledge on how to change a column type in PostgreSQL (and other systems compliant with the SQL standard) is to:
Artur Zakirov: Saturation Arithmetic with a PostgreSQL Extension
Deepak Mahto: Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration
Oracle to PostgreSQL migration is a playground that uncovers and touches upon many database concepts, which are always intriguing and fun to explore. Implicit Conversion, i.e., imposing automatic conversion on data types to make them comparable by database optimizers, is also a concept frequently encountered in database migrations. Implicit conversion allows for the automatic conversion of data types for an expression or condition when necessary for SQL execution, thus preventing failures.
David Z: Bringing IvorySQL to Neon Autoscaling Platform
In this blog post, we will guide you through the process of integrating IvorySQL, an open-source database built on PostgreSQL, into Neon Autoscaling Platform. Throughout this guide, we’ll walk you through each step, providing clear instructions and demonstrations.
Pavel Borisov: What's new in pgvector v0.7.0
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.