A couple of days ago I wrote that Postgres 19 is late and that three big features were dropped along the way. Fortunately, among what does make it there’s something many people who run Postgres have been waiting …
Five months ago, PostHog rebuilt its data warehouse on DuckDB. Now Benjamin Knofe-Vider explains in Why we’re moving our warehouse off DuckDB why they’re leaving it. It caught my attention for two reasons: a …
If there’s one open source project you can rely on for planning, it’s PostgreSQL. For a decade now, every major version has shipped between mid-September and mid-October, with a regularity many commercial …
The DuckDB team has released DuckDB 2.0.0 LTS “Cinnamon Teal”, named after a duck as always: the cinnamon teal, a reddish-brown duck from the western Americas. If 1.0 was the stability release, 2.0 is, …
When you work with geographic data at scale, sooner or later you end up using a global grid: splitting the planet into cells, each with a numeric identifier, and assigning every point, line or polygon to the cells it …
DELETE has a bad reputation in Postgres. Many performance-sensitive systems avoid deleting rows and prefer to empty whole tables with TRUNCATE or drop entire partitions by date. Peter Kraft and Qian Li, from DBOS, have …
Anyone who has taken Postgres to production under some load has been through the same thing: you put PgBouncer or PgCat in front, configure transaction pooling, cap the real server connections so it doesn’t run out …
On August 26th, Mark Raasveldt and Hannes Mühleisen published a very short note on the DuckDB blog: DuckLabs, the company behind DuckDB, is becoming a subsidiary of Amazon Web Services. The deal closes in early …
In April 2021 I made my first commit to the monorepo behind CARTO’s cloud-native platform. It was PR number 9, a docker-compose. Five years later I’ve looked back with some calm and found around 450 commits, …
The problem: httpfs ignores your environment variables If you work with DuckDB and the httpfs extension to read remote Parquet files, CSVs from S3, or any HTTP resource, you probably assume that the HTTP_PROXY and …
Every query starts with a plan. Every slow query probably starts with a bad one. And more often than not, the statistics are to blame. But how does it really work? PostgreSQL doesn’t run the query to find out — it …
Lately I’ve been working quite a bit with DuckDB, and one of the things that interests me most is understanding how to optimize performance according to the file format we’re using. It’s not the same …
