News for hackers. Stuff that matters.
Re:PostgreSQL 14 by maxpert on Thursday September 30, 2021 @09:16AM (#28705914)
I converted from MySQL (before whole MariaDB and fork), and I've been happier with every new version. My biggest moment of joy was JSONB and it keeps getting better. Can we please make the connections lighter so that I don't have to use stuff like pgbouncer in the middle? I would love to see that in future versions.
Re:PostgreSQL 14 by paulryanrogers on Thursday September 30, 2021 @09:27AM (#28706034)
FWIW Mysql 8 has gotten a lot better in standards compliance and ironing out legacy quirks, with some config tweaks. While my heart still belongs to PostgreSQL things like no query hints, dead tuple bloat (maybe zheap will help?), less robust replication (though getting better!), and costly connections dampens my enthusiasm.
Re:PostgreSQL 14 by assface on Thursday September 30, 2021 @10:35AM (#28706822)
> maybe zheap will help?

According to Robert Haas, the zheap project is dead.

Re:PostgreSQL 14 by eurg on Thursday September 30, 2021 @12:11PM (#28708003)
Where did Robert Haas say this? Quick search didn't surface much, except for a blog post from July by Hans-Jürgen Schönig: https://www.cybertec-postgresql.com/en/postgresql-zheap-curr... Doesn't sound like they discontinued the project.
Re:PostgreSQL 14 by Tostino on Thursday September 30, 2021 @01:11PM (#28708638)
I'd love to see that info, been interested in why it was taken up by Cybertec and EDB seemingly dropped it.
Re:PostgreSQL 14 by darksaints on Thursday September 30, 2021 @09:57AM (#28706372)
There has been a lot of improvement in this release.

https://www.depesz.com/2020/08/25/waiting-for-postgresql-14-...

Re:PostgreSQL 14 by the_duke on Thursday September 30, 2021 @10:42AM (#28706882)
The benchmark linked in the comments shows 7-38% improvements. Nothing to scoff at, but if you need PGBouncer that probably won't make enough of a difference.
Re:PostgreSQL 14 by darksaints on Thursday September 30, 2021 @10:57AM (#28707089)
It certainly isn't much of an improvement in connection latency (the connections are still pretty heavy), but it is a massive improvement in transaction throughput with higher numbers of connections. If you scroll down a bit, there is now higher TPS even at 5000 connections than previously could be had at 100 connections. That fixes a massive amount of pain that previously only could be solved with pgbouncer.
Re:PostgreSQL 14 by jkatz05 on Thursday September 30, 2021 @09:44AM (#28706217)
I'd be curious to see if the concurrency improvements in PostgreSQL 14 help with increasing the threshold for when you need to introduce a connection pooler.
Re:PostgreSQL 14 by darksaints on Saturday October 02, 2021 @09:04PM (#28733649)
Check out the Azure team's benchmarks. Pretty damn impressive.

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

Re:PostgreSQL 14 by xwdv on Thursday September 30, 2021 @09:35AM (#28706118)
Lighter connections would finally allow for using lambda functions that access a Postgres database without needing a dedicated pgbouncer server in the middle.
Re:PostgreSQL 14 by jeltz on Thursday September 30, 2021 @12:20PM (#28708108)
Yes, but this patch does not make startup cheaper, it only decreases the performance cost of concurrent open connections.
Re:PostgreSQL 14 by plasma on Thursday September 30, 2021 @06:16PM (#28712006)
Not sure if you’re using this, but AWS has RDS Proxy as a service, in case you’re hosting your own