Sammlung von Newsfeeds
David Rowley: What’s new in the Postgres 16 query planner / optimizer
PostgreSQL 16 introduces quite a few improvements to the query planner and makes many SQL queries run faster than they did on previous versions of PostgreSQL.
If you look at the PG16 release notes, you’ll see some of these planner improvements. But with the volume of changes made in each PostgreSQL release, it’s not possible to provide enough detail about each and every change. So maybe you might need a bit more detail to know what the change is about—before you understand if it’s relevant to you.
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Support identity columns in partitioned tables
Andreas Scherbaum: PostgreSQL February Meetup in Berlin
On February 6th, 2024, we had the PostgreSQL February Meetup in Berlin.
Christoph Berg: FOSDEM 2024 in Brussels
Paul Ramsey: Building the PgConf.Dev Programme
The programme for pgconf.dev in Vancouver (May 28-31) has been selected, the speakers have been notified, and the whole thing should be posted on the web site relatively soon.
I have been on programme committees a number of times, but for regional and international FOSS4G events, never for a PostgreSQL event, and the parameters were notably different.
Luca Ferrari: pgenv gains a new command (and contributor!)
A new command in the pgenv script.
pgenv gains a new command (and contributor!)[pgenv](https://github.com/theory/pgenv){:target="_blank"} , the PostgreSQL binary manager written as a Bourne Again Shell script, has gained a new command: status.
Adrien Nayrat: Postgres again elected DBMS of the Year in 2023, but I'm worried
Once again, Postgres has been elected DBMS of the Year by DB-Engines. Although this is only a ranking, it gives a trend. It has also been recognized for several years in Stackoverflow surveys : Most popular Databases.
Ricardo Zavaleta: Pgvector vs Lantern part 2 - The one with parallel indexes
Three weeks ago, we wrote a blog comparing pg_vector and lantern on index creation and search speed, and also mentioned that this is a fast evolving space with great momentum.
Just last week, we saw the release of Pgvector v0.6.0, which contains improvements in HWSW build time thanks to the ability to build indexes in parallel.
Luca Ferrari: Changing a Column from Integer to Boolean in One Transaction
A way to fix some oddity that comes from other databases.
Changing a Column from Integer to Boolean in One TransactionI was migrating a database from SQLite3 to PostgreSQL, not because the former isn’t good, rather because the latter shines!
Henrietta Dombrovskaya: Tuning Parameters vs Tuning Queries: presentation and recording
The presentation I gave for Chicago PUG in January was a reserved talk for FOSDEM, so I hold of with sharing until after the conference. Now that the conference is over, here is it!
Jeremy Schneider: UUID Benchmark War
This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war.
I have decided to orchestrate a benchmark war between four different methods of storing a primary key:
Dan Langille: could not open certificate file “/root/.postgresql/postgresql.crt”: Permission denied
Lætitia AVROT: PGSQL Phriday #015: Primary keys: UUID, CUID, or TSID?
Pavlo Golub: Postgres.AI bot interview for PGSQL Phriday #015
This month, we have an invitation from Lætitia to talk about UUIDs. UUIDs are a hot topic, and Cybertec wrote several posts earlier.
Francesco Tisiot: How to load JSON data in PostgreSQL with the the COPY command
You have a JSON dataset that you want to upload to a PostgreSQL table containing properly formatted rows and columns... How do you do it?
All the main sources like my own blog and others tell you to load the JSON in a dedicated temporary table containing a unique JSON column, then parse it and load into the target table. However there could be another way, avoiding the temp table!
Jagadeesh Panuganti: Data Navigation with PostgreSQL Cursors – Part II
Welcome back to the second article in our series exploring PostgreSQL cursors. In the first part of this series, we explored the fundamentals of scrollable cursors. In this article, we’ll shift our focus to non-scrollable cursors and explore how they can enhance your data navigation experience with PostgreSQL Cursors. Understanding Non-Scrollable Cursors Non-scrollable cursors in […]
David Wheeler: Contemplating Decentralized Extension Publishing
As I think through the future of the Postgres extension ecosystem as a key part of the new job, I wanted to understand how Go decentralized publishing works. In this post I work it out, and think through how we might do something similar for Postgres extension publishing.