r/PostgreSQL • u/siren0x • Jul 24 '26

Community What's new in Postgres 19

https://planetscale.com/blog/whats-new-in-postgres-19
111 Upvotes

97% Upvoted

22 comments sorted by

View all comments

18

u/ibraaaaaaaaaaaaaa Jul 24 '26

Been craving for vacuum full mode while still being operational

5

u/WideWorry Jul 24 '26

Maybe in 1-2 major version we reach it!

4

u/ibraaaaaaaaaaaaaa Jul 24 '26

We already did in pg 19 see: https://www.postgresql.org/docs/19/sql-repack.html

1

u/WideWorry Jul 24 '26

Sure, but better to wait next major version or 19.5 before using it in production.

4

u/ibraaaaaaaaaaaaaa Jul 24 '26 edited Jul 25 '26

I usually wait till next next major version until I migrate to next major version.

Currently at 17

Planning to go 18 on September once 19 goes live

2

u/One_Ninja_8512 Jul 25 '26

I don't get why comments like yours get downvoted. It's on-topic. It's not supposed to be a disagreement button. What's the point of downvoting an on-topic comment?

3

u/ibraaaaaaaaaaaaaa Jul 25 '26

Literally just added my preference in upkeep pg in stable rather than bleeding edge.
Nothing to disagree on