Postgres 19 Beta 1 Released | Scaling Postgres 420

Our first piece of content is PostgreSQL 19 Beta 1 is released.

And we'll just take a look at the feature highlights.

So in the performance area, they're talking about changes to the async IO system, where it now automatically handles workers.

You just give it a min and max, and it handles it.

They're talking about the new PG plan advice extension that's being released.

The fact that you can now do auto vacuuming in parallel.

They mentioned the new repack command and repack concurrently to compress your tables.

And I always see things that I haven't heard of before and I want to know more information.

But it says, quote, PostgreSQL 19 shows up to two times better performance on inserts when foreign key checks are present.

So I don't recall any blog post discussing this feature, and I actually want to learn more about this, but I haven't looked it up yet.

And various other performance benefits with regard to the planner.

They talk about developer experience with regard to introducing SQLPGQ.

which is for doing graph queries.

We'll see two blog posts discussing that in this show.

They mentioned the merge and splitting of partitions.

You can now return rows from an on-conflict doSelect.

But of course they have many more features.

They've enhanced security, added more monitoring and observability, and of course continuing to every version improve the logical replication capabilities.

So definitely check this out if you want to learn more.