Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL 16 Beta 1

postgresql.org

Post reply on HN
Print view View original

51–60 of 62 posts

Re: PostgreSQL 16 Beta 1

#51

Post by anarazel »

jeltz wrote: post #49

I am personally very excited to see that work on direct IO has started. It is a huge undertaking so I do not expect any production ready thing any time soon but nice to see that some code landed.

Yeah- we've been working on that for quite a while, and it'll take a few more years to finish it. I hope we can get some important parts into 17 though.

FWIW, there have been smaller prerequisites merged into 15 already, and 16 has a number of improvements that are part of that work. E.g. the more scalable relation extension (making COPY scale much better), and the related buffer mapping changes, come from the AIO effort.

Personally I think the feature is using asynchronous IO and direct IO support is part of that :)

Re: PostgreSQL 16 Beta 1

#52

Post by cryptonector »

garyclarke27 wrote: post #5

Postgresql is amazing but I must say the last few updates have been a bit disappointing. Still waiting for automatic incremental updates for materialized views - been worked on for several years but still not released! https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc... https://github.com/sraoss/pg_ivm

You can use https://github.com/twosigma/postgresql-contrib/blob/master/m... and write triggers to update your views or mark them as needing asynchronous refreshes. It's not as automatic as what you'd like, but it's a lot better than having to keep waiting.

Re: PostgreSQL 16 Beta 1

#54

Post by ksec »

samwillis wrote: post #37
tensor wrote: post #13

Earlier quoted context omitted.

To be fair view update is a very hard problem in computer science. It's not as though it's just a lack of time to implement it.

https://materialize.com/ are doing interesting things with this - although not inside Postgres (they use a few bit of Postgres as components).

I think PlanetScale implement something similar.

https://planetscale.com/blog/how-planetscale-boost-serves-yo...

Re: PostgreSQL 16 Beta 1

#55

Post by dawidpotocki »

ComputerGuru wrote: post #47
hans_castorp wrote: post #12

Earlier quoted context omitted.

> I'd love to have another upgrade path than `pg_dump | psql` pg_upgrade

pg_upgrade is not an option on many systems if you are installing with the package manager as it requires both old and new binaries to be simultaneously present.

Arch Linux e.g. solved this by having a `postgresql-old-upgrade` package.

Re: PostgreSQL 16 Beta 1

#56

Post by hans_castorp »

ComputerGuru wrote: post #47
hans_castorp wrote: post #12

Earlier quoted context omitted.

> I'd love to have another upgrade path than `pg_dump | psql` pg_upgrade

pg_upgrade is not an option on many systems if you are installing with the package manager as it requires both old and new binaries to be simultaneously present.

Well, that's a problem of the package manager, not a Postgres problem.

At least with Ubuntu and RedHat/CentOS/Rocky/... installing two versions in parallel is absolutely no problem.

I think Ubuntu even wraps that into their upgrade scripts and you can pass an option to use pg_upgrade or pg_dump/pg_restore

Re: PostgreSQL 16 Beta 1

#57

Post by ttfkam »

dalyons wrote: post #18
Fgehono wrote: post #10

Earlier quoted context omitted.

Could you elaborate on the load balancing? Is this a replacement for PG bouncer and similar?

IMO the biggest reason folks use pgbouncer is not for load balancing (which it can do, -ish) but instead for connection pooling. Postgres connections are expensive for the db server (one process per connection not one thread) so if you have say thousands of web application pods you need to use pgbouncer or similar as a proxy to multiplex those thousands of connections down onto a more manageable number (~200). So no,…

Postgres 14 already made huge improvements on this front.

https://techcommunity.microsoft.com/t5/azure-database-for-po...

Re: PostgreSQL 16 Beta 1

#58

Post by jkatz05 »

LunaSea wrote: post #40
phamilton wrote: post #17

Earlier quoted context omitted.

AWS has gotten much better in recent years. Pg15 is available on Aurora as of last month. That's about 6-7 months after it was released, a significant improvement over years past.

Yup, but the lack of access to beta versions also means that we will basically get access to access to PostgreSQL 16 in RDS by next year around this time.

Hey, I helped to write the original article, and I also work at AWS.

I'm happy to let you know that PostgreSQL 16 Beta 1 is available in the Amazon RDS Database Preview Environment (https://aws.amazon.com/about-aws/whats-new/2023/05/postgresq...). I hope you get a chance to test, I'm very eager to here any and all feedback about PostgreSQL 16.

Re: PostgreSQL 16 Beta 1

#59

Post by sureglymop »

tracker1 wrote: post #45
sureglymop wrote: post #44

Earlier quoted context omitted.

Is MSSQL used often in production? And where are all the windows servers this would run on?

Yes... many, many internal deployments are definitely using MS-SQL services. StackOverflow.com uses MS-SQL, for a prominent, public example. There are client libraries via ODBC or direct in many languages and platforms, including Node.js (mssql/tedious) and Rust. As to where, AWS offers Windows as do many other cloud providers, including a significant portion of Azure VMs. Not to mention, that MS-SQL and SQL-Edge bot…

That's really interesting, a lot of that is new information to me! Thank you for the detailed response, I appreciate it.

Re: PostgreSQL 16 Beta 1

#60

Post by LunaSea »

jkatz05 wrote: post #58
LunaSea wrote: post #40

Earlier quoted context omitted.

Yup, but the lack of access to beta versions also means that we will basically get access to access to PostgreSQL 16 in RDS by next year around this time.

Hey, I helped to write the original article, and I also work at AWS. I'm happy to let you know that PostgreSQL 16 Beta 1 is available in the Amazon RDS Database Preview Environment ( https://aws.amazon.com/about-aws/whats-new/2023/05/postgresq... ). I hope you get a chance to test, I'm very eager to here any and all feedback about PostgreSQL 16.

Thanks for the info!

Would you also know by any chance when RDS will get Graviton3 instances in non-Dublin EU regions?

Post reply on HN