News for hackers. Stuff that matters.
Re:Improving Postgres Connection Scalability: Snapshots by vorpalhex on Tuesday October 27, 2020 @10:12AM (#24907590)
That might of been a serious problem in 1995, but certainly throwing 64-128gb of ram at a postgres box isn't that uncommon?

I'm also curious how you got 10mb per connection (if I'm reading your parenthetical correctly). I've seen a PG box with a few hundred active connections sitting happily at just a gig of ram. Obviously WHAT you do with those connections may well change that but that isn't pg-wire overhead.

Re:Improving Postgres Connection Scalability: Snapshots by user5994461 on Tuesday October 27, 2020 @12:02PM (#24908726)
It's uncommon to throw 128 GB at a postgres. Remember that the world has moved to the cloud, where you pay a hefty fee per GB.

It's entirely possible to throw gigabytes of RAM as long as the company is willing to foot the bill. You're going into thousands of dollars per month depending how big and how many replicas we're talking about.