Sammlung von Newsfeeds

Adrien Nayrat: Recommended resources to improve your knowledge of Databases and PostgreSQL

Neues vom PostgreSQL Planet - 12. Februar 2024 - 9:00
Table of Contents

Dian Fay: (Plausible) Random Geography Generation with PostGIS: Fluviation

Neues vom PostgreSQL Planet - 12. Februar 2024 - 1:00

Welcome to Squaria.

Squaria is a continent of highly unstable geography defined by a single SQL query (with, as we'll see, many, many CTEs). Its only consistent properties at the moment are its boxy shape and the two unnervingly straight mountain ranges that cross its breadth and meet on its lower eastern edge. Those mountains are impossible, but today's topic is fluviation, that is, rivers and riverine lakes; we'll see about plausible plate tectonics some other time, maybe.

Ryan Lambert: Hosting a set of Postgres Demo databases

Neues vom PostgreSQL Planet - 10. Februar 2024 - 6:01

In April 2023, I submitted my proposal for a full-day pre-conference at PASS 2023. My chosen topic was focused on PostGIS, titled GIS Data, Queries, and Performance. A key part of my submission was that the session would be an interactive, follow-along type design. Julie and I believe that doing is key to learning so we wanted to enforce that as much as possible.

Luca Ferrari: pgagroal-cli gains JSON output

Neues vom PostgreSQL Planet - 10. Februar 2024 - 1:00

A new feature of pgagroal-cli that now makes another step towards the full automation.

pgagroal-cli gains JSON output

At last, I made it: a commit in pgagroal to support JSON output. It has been quite hard and long, not for the technological challenge, rather for all the little details like continuos integration, to get this work completed. As a rule of thumb, I stated this work last November (of course, slowly working in and out).

David Z: Enhance PostgreSQL TLS Security with OCSP Stapling

Neues vom PostgreSQL Planet - 9. Februar 2024 - 21:41
1. Overview

In my previous blog, I discussed how to quickly set up a TLS connection between a PostgreSQL server and a psql client. In this blog, I will guide you through the process of setting up a TLS connection using OCSP Stapling, which can help improve the security of PostgreSQL.

2. What is OCSP Stapling?

Before diving into how to enable OCSP Stapling with PostgreSQL, we need to understand some basic concepts:

Greg Sabino Mullane: Postgres Not Starting: The Case of the Missing Output

Neues vom PostgreSQL Planet - 9. Februar 2024 - 14:00
Strangely quiet around here

My colleague Bob Pacheco asked me to help with a strange problem he was witnessing for a client. A new Postgres cluster was getting created on a Kubernetes node, but it refused to start.

Stefan Fercot: Back from FOSDEM 2024

Neues vom PostgreSQL Planet - 9. Februar 2024 - 13:17

Everyone knows FOSDEM, right?
The PostgreSQL Project has been present there with a booth and a Devroom since more than 15 years now!
And this year there was the 10th FOSDEM PGDay organized on the Friday before FOSDEM.

I had the chance to spend 3 days with awesome #PostgresFriends and even more free and open source software aficionados.
Here’s a short writing of how I lived those exhausting but very exciting days.

Pavel Stehule: new extension pgmeminfo

Neues vom PostgreSQL Planet - 8. Februar 2024 - 19:19

I wrote very simple extension pgmeminfo for PostgreSQL12+, that should to help with investigation of memory usage by Postgres. Function pgmeminfo returns glibc information about memory usage provided by function mallinfo(). It is much more precious than usage top or htop.

Karen Jex: Learning about "transqlate" at PG Session 16

Neues vom PostgreSQL Planet - 8. Februar 2024 - 18:48

After the craziness of the FOSDEM weekend in Brussels (FOSDEM PGDay, and the PostgreSQL booth and Devroom at FOSDEM itself) I headed to Paris for

David Rowley: What’s new in the Postgres 16 query planner / optimizer

Neues vom PostgreSQL Planet - 8. Februar 2024 - 18:16

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

Neues vom PostgreSQL Planet - 7. Februar 2024 - 22:41
On 16th of January 2024, Alexander Korotkov committed patch: Add new COPY option SAVE_ERROR_TO   Currently, when source data contains unexpected data regarding data type or range, the entire COPY fails. However, in some cases, such data can be ignored and just copying normal data is preferable.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Support identity columns in partitioned tables

Neues vom PostgreSQL Planet - 7. Februar 2024 - 21:12
On 16th of January 2024, Peter Eisentraut committed patch: Support identity columns in partitioned tables   Previously, identity columns were disallowed on partitioned tables. (The reason was mainly that no one had gotten around to working through all the details to make it work.) This makes it work now.   Some details on the behavior: … Continue reading "Waiting for PostgreSQL 17 – Support identity columns in partitioned tables"

Andreas Scherbaum: PostgreSQL February Meetup in Berlin

Neues vom PostgreSQL Planet - 7. Februar 2024 - 20:43

On February 6th, 2024, we had the PostgreSQL February Meetup in Berlin.

Paul Ramsey: Building the PgConf.Dev Programme

Neues vom PostgreSQL Planet - 6. Februar 2024 - 17:00

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!)

Neues vom PostgreSQL Planet - 6. Februar 2024 - 1:00

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

Neues vom PostgreSQL Planet - 5. Februar 2024 - 9:00

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

Neues vom PostgreSQL Planet - 5. Februar 2024 - 1:00

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.

Seiten