News for hackers. Stuff that matters.

A comment on PostgreSQL 9.6 Released. Parent comment

Re:PostgreSQL 9.6 Released by greggyb on Thursday September 29, 2016 @09:24AM (#12605009)
No one has tested a query that got more than 32x faster, so they don't want to promise something they can't prove.
[ Parent | on HN ]
Re:PostgreSQL 9.6 Released by Jweb_Guru on Thursday September 29, 2016 @03:12PM (#12607982)
There's also a limited amount of memory-level parallelism available... with 4-DIMM sockets you might need an 8-socket machine to get a 32x improvement on large (memory-bound) sequential scans, which I'd guess you can get on top-end Power machines.

(You can probably get more memory level parallelism with random access, but your overall bandwidth will likely be lower... fully exploiting memory bandwidth is complicated and difficult to do for real applications).

[ Parent | on HN ]
Re:PostgreSQL 9.6 Released by joshberkus on Monday October 03, 2016 @06:47PM (#12631990)
That's pretty much the case, yes.
[ Parent | on HN ]