Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 48 Minuten 12 Sekunden

Laurenz Albe: Type alignment and padding bytes: how to not waste space in PostgreSQL tables

22. April 2025 - 7:00


© Laurenz Albe 2025

Saving storage space should not be your first objective in a PostgreSQL database. Very often, the desire to conserve space aggressively comes at the expense of performance. But there is also no reason to needlessly waste space. Therefore, it is a good idea to be familiar with the concepts of data type alignment and padding bytes in PostgreSQL.

David Wheeler: Mini Summit 4: The User POV

21. April 2025 - 19:26

And we’re back.

Ian Barwick: PgPedia Week, 2025-04-20

20. April 2025 - 22:10
PostgreSQL 18 changes this week

With all five CommitFests over, we're now into the testing and bugfix phase, and no new features are likely to be added. Having said that, there have been a few tweaks to SQL function performance and handling this week.

Floor Drees: Contributions for the week of 2025-04-14 (Week 15)

20. April 2025 - 19:31

April 9 Christoph Berg spoke at the Postgres Extensions Ecosystem Mini-Summit #3 (slides, recording, transcript), a series of virtual events leading up to the gathering at PGConf.Dev.

Floor Drees: Contributions for the week of 2025-04-07 (Week 14)

20. April 2025 - 19:28

April 2nd the Talking Postgres podcast airs live, with Claire Giordano as the host, Bruce Momjian as the guest, and Aaron Wislang as its producer.

Henrietta Dombrovskaya kicked off Prairie Postgres, with help from Pat Wright, Dian Fay and Anna Bailliekova.

Floor Drees: Contributions for the week of 2025-03-31 (Week 13)

20. April 2025 - 16:58

Gülçin Yıldırım Jelínek organized the [Prague PostgreSQL Meetup, March Edition on March 31st]((https://www.meetup.com/prague-postgresql-meetup/events/306440481). Mayuresh B and Tomáš Vondra presented sessions.

Floor Drees: Contributions for the week of 2025-03-24 (Week 12)

20. April 2025 - 16:49

Nordic PGDay (March 18) was organized by Daniel Gustafsson, Magnus Hagander, Georgios Kokolatos.

The following speakers contributed with a talk:

Floor Drees: Contributions for the week of 2025-03-17 (Week 11)

20. April 2025 - 16:21

PostgreSQL Person of the week: Emma Saroyan

... Thanks Andreas Scherbaum, for publishing these interviews since - checks notes - February 2020!

Pavel Stehule: Article about PostgreSQL 18

19. April 2025 - 16:11

I wrote an article about PostgreSQL 18.  It is in Czech language, but translators from Czech to English, German, ... works relatively well today.

 https://www.root.cz/clanky/postgresql-18-tricet-let-otevreneho-vyvoje-databaze/

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.

17. April 2025 - 12:44
On 5th of April 2025, Álvaro Herrera committed patch: Add modern SHA-2 based password hashes to pgcrypto.   This adapts the publicly available reference implementation on https://www.akkadia.org/drepper/SHA-crypt.txt and adds the new hash algorithms sha256crypt and sha512crypt to crypt() and gen_salt() respectively.

David Wheeler: Fix Postgres <code>strchrnul</code> Compile Error on macOS 15.4

16. April 2025 - 21:03

Just a quick note to users of pgenv and anyone else who compiles Postgres on macOS. In macOS 15.4, Apple introduced a new API, strchrnul, which is common from other platforms. As a result attempting to compile Postgres on 15.4 and later will lead to this error:

Louise Grandjonc: Hacking the Postgres Statistics Tables for Faster Queries

16. April 2025 - 15:00

Postgres does a great job of making queries really efficient. By gathering data in internal statistics tables, Postgres estimates before a query is run lots of things - like will an index scan be better than a sequential scan. How to pull data for the WHERE statement.

Bruce Momjian: New User Management Presentation Online

16. April 2025 - 2:45

I wrote User, User, Who Is the User? in January of 2024, but didn't publish the slides at that time. I was planning to publish them once I delivered the presentation, but it has been a year and I have still not deivered the talk, so I am now publishing the slides.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore

15. April 2025 - 12:46
On 4th of April 2025, Andrew Dunstan committed patch: Non text modes for pg_dumpall, correspondingly change pg_restore   pg_dumpall acquires a new -F/--format option, with the same meanings as pg_dump. The default is p, meaning plain text. For any other value, a directory is created containing two files, globals.data and map.dat.

semab tariq: Finding Bottlenecks and Avoiding Over-Optimization via Explain Plans

15. April 2025 - 10:27

Performance optimization in a production database is important, but trying to over-optimize can make things more complicated without real improvements.

In this post, I’ll share two very basic EXPLAIN ANALYZE outputs from a production system. A user asked us to help optimize these queries. I've changed the table and column names for privacy. We will look at how to spot slow parts of a query, improve performance the right way, and avoid unnecessary tuning.

Plan A: Identifying and Resolving a Bottleneck

Hans-Juergen Schoenig: Indexing vectors in PostgreSQL

15. April 2025 - 7:00

In the previous post we have imported a fairly large data set containing Wikipedia data, which we downloaded using pgai. However, importing all this data is not enough because we also need to keep an eye on efficiency. Therefore, it is important to understand that indexing is the key to success.

In general, pgvector provides us with two types of indexes that we can use:

- hnsw
- ivfflat

David Wheeler: Mini Summit 3 Transcript: Apt Extension Packaging

15. April 2025 - 0:48

Last week Christoph Berg, who maintains PostgreSQL’s APT packaging system, gave a very nice talk on that system at the third PostgreSQL Extension Mini-Summit.

Jim Mlodgenski: Improvements in Expanded Objects in PostgreSQL 18

14. April 2025 - 16:14

 Way back in PostgreSQL 9.5, there was a simple entry in the release notes:

Improve PL/pgSQL array performance (Tom Lane)


Luca Ferrari: PgTraining OpenDay is over!

14. April 2025 - 2:00

We are proud of what we have done in Bolzano.

PgTraining OpenDay is over!

Last Friday was PgTraining OpenDay in Bolzano, a free of charge day entirely dedicated to PostgreSQL, that we at PgTraning organized.

Ian Barwick: PgPedia Week, 2025-04-13

13. April 2025 - 22:29

Well, the code freeze has come and gone, so it's all over for PostgreSQL 18 development, bar the testing. RC1 is likely due at the start of September, so fire up those test environments sooner rather than later!

Any new features from here on out will be for the future PostgreSQL 19 , whose first CommitFest will start in July ( 2025-07 ).

Seiten