Planet PostgreSQL (Unofficial)

596 Followers
0 Following
1.9K Posts
Blog entries from members of the PostgreSQL community.
URLhttps://planet.postgresql.org/
Join us in Riga, Latvia on 21-24 October - PGConf.EU 2025 - PostgreSQL Europe

Andrei Lepikhov: Fractional Path Issue in Partitioned Postgres databases https://danolivo.substack.com/p/fractional-path-issue-in-partitioned
#postgres #postgresql
Fractional Path Issue in Partitioned Postgres databases

Continuing discovery on Postgres planner weak points

Conserving CPU's cycles ...
The bus factor problem - BostonGIS

PG Phriday: Whats Our Vector Victor

Postgres Conference Seattle 2024 partnered up with PASS this year to present a united database front. They accepted my “What’s our Vector, Victor?” talk, which I graciously gave on the first day of the conference. If you weren’t there and missed out on the fun, this is your chance to catch up and maybe get a bit more information that was cut for length. Let me tell you why RAG is the future, and how Postgres and pg_vectorize make it a reality.

PGConf.EU 2024 Review

PGConf.EU 2024 in Athens is over - time to look back and recap the conference. It was the largest PostgreSQL conference organized by PostgreSQL Europe - so far.

ads' corner
Jimmy Angelakos (@vyruss): Contributions for the week of 2024-11-25 (Week 48 overview) https://postgres-contrib.org/post/26/
#postgres #postgresql
Contributions for the week of 2024-11-25 (Week 48 overview)

Contributions for the week of 2024-11-25 (Week 48 overview) | Ayse Bilge Ince was interviewed as

postgres-contrib.org
Umair Shahid: VACUUM FULL in PostgreSQL – What you need to be mindful of https://stormatics.tech/blogs/vacuum-full-in-postgresql
#postgres #postgresql
PostgreSQL Hacking Workshop - January 2025

Next month, I'l be hosting 2 or 3 discussions of Andres Freund's talk,  NUMA vs PostgreSQL , given at PGConf.EU 2024. You can sign up using ...

Jônatas Paganini: Counter Analytics in PostgreSQL: Beyond Simple Data Denormalization https://www.timescale.com/blog/counter-analytics-in-postgresql-beyond-simple-data-denormalization
#postgres #postgresql
Counter Analytics in PostgreSQL: Beyond Simple Data Denormalization

Record counting on demand or denormalized counters? We break down the two and show you an alternative using PostgreSQL.

Timescale Blog
Jônatas Paganini: Counter Analytics in PostgreSQL: Beyond Simple Data Denormalization https://www.timescale.com/blog/counter-analytics-in-postgresql-beyond-simple-data-denormalization
#postgres #postgresql
Counter Analytics in PostgreSQL: Beyond Simple Data Denormalization

Record counting on demand or denormalized counters? We break down the two and show you an alternative using PostgreSQL.

Timescale Blog