Sammlung von Newsfeeds
Pavel Luzanov: PostgreSQL 18: part 1 or CommitFest 2024-07
This article is the first in the series about the upcoming PostgreSQL 18 release. Let us take a look at the features introduced in the July CommitFest.
Greg Smith: Loading the World! OpenStreetMap Import In Under 4 Hours
The OpenStreetMap (OSM) database builds almost 750GB of location data from a single file download. OSM notoriously takes a full day to run. A fresh open street map load involves both a massive write process and large index builds. It is a great performance stress-test bulk load for any Postgres system. I use it to stress the latest PostgreSQL versions and state-of-the-art hardware. The stress test validates new tuning tricks and identifies performance regressions.
semab tariq: What Happens Behind the Scenes When You Modify a Row in PostgreSQL?
Data is often called the new gold, and databases are where we store and manage this precious resource as it constantly changes and grows. At first glance, updating data might seem like a simple task—just modify a row.
But behind the scenes, it’s more complex to ensure that data remains consistent and accessible. In today’s blog, I’ll answer some frequently asked questions from our customers and dive into why PostgreSQL relies on a process called VACUUM to efficiently manage data updates.
Andreas Scherbaum: PGConf.EU 2024 Lightning Talks
Kaarel Moppel: Postgres on Spot VMs - only for the crazy?
Jimmy Angelakos: Contributions for the week of 2024-11-11 (Week 46 overview)
- November 12th: Katherine Saar, Stacey Haysler and Christophe Pettus hosted an online meetup for PostgreSQL San Francisco Area User Group, "Be Thankful: Logical Replication traps you did not fall into", presented by Kacey Holston.
- November 12th: Floor Drees published an episode for the "Hacking Postgres" podcast S3E2 (
Elizabeth Garrett Christensen: Easy Totals and Subtotals in Postgres with Rollup and Cube
Postgres is being used more and more for analytical workloads. There’s a few hidden gems I recently ran across that are really handy for doing SQL for data analysis, ROLLUP and CUBE. Rollup and cube don’t get a lot of attention, but follow along with me in this post to see how they can save you a few steps and enhance your date binning and summary reporting.
Andreas 'ads' Scherbaum: Ayse Bilge Ince
Luca Ferrari: dbicdump: using PostgreSQL schemas as package separator in produced Perl classes
A way to instrument dbicdump to use PostgreSQL schemas as package separators.
dbicdump: using PostgreSQL schemas as package separator in produced Perl classesPerl DBIx::Class is a great Object Relational Mapper (ORM), and I use it regularly with dbicdump, which is a tool to synchronize your existing database structure with the classes your program is going to use.
Gülçin Yıldırım Jelínek: Prague PostgreSQL Meetup on November 18th
Christophe Pettus: The Doom That Came To PostgreSQL: When Collations Change
In this installment of our series on locales and PostgreSQL, we’ll talk about what can happen with the library that provides locales changes out from under a PostgreSQL database. It’s not pretty.
Douglas Hunley: On CVEs, BoMs, and Releases
Craig Kerstiens: A change to RelResultInfo - A Near Miss with Postgres 17.1
Since its inception Crunchy Data has released new builds and packages of Postgres on the day community packages are released. Yesterday's minor version release was the first time we made the decision to press pause on a release. Why did we not release it immediately? There appeared to be a very real risk of breaking existing installations. Let's back up and walk through a near miss of Postgres release day.
Hubert 'depesz' Lubaczewski: Grouping data into array of sums – fun with custom aggregates
Christophe Pettus: Farm to TABLE: Local(e) Providers
In our this installment about character encodings, locations, and locales in PostgreSQL, we’re talking about locale providers.
A reminder about localesA “locale” is a bundled combination of data structures and code that provides support services for handling different localization services. For our purposes, the two most important things that a locale provides are:
Gülçin Yıldırım Jelínek: Recap of PGConf.EU 2024 in Athens
Umair Shahid: Transitioning from Oracle to PostgreSQL: Concurrency Control
Transitioning from Oracle to PostgreSQL can be a transformative experience for database administrators because of the subtle differences between the two technologies. Understanding how the two handle concurrency differently is critical to managing highly concurrent workloads.
Robert Haas: PostgreSQL Hacking Workshop - December 2024
Next month, I'll be hosting a discussion of Melanie Plageman's talk, Intro to Postgres Planner, given at PGCon 2019. You can sign up using this form. To be clear, the talk is not an introduction to how the planner works from a user perspective, but rather how to hack on it and try to make it better and perhaps get your improvements committed to PostgreSQL. If you're interested, please join us.
Paul Ramsey: Accessing Large Language Models from PostgreSQL
Large language models (LLM) provide some truly unique capacities that no other software does, but they are notoriously finicky to run, requiring large amounts of RAM and compute.
That means that mere mortals are reduced to two possible paths for experimenting with LLMs:
