News for hackers. Stuff that matters.
Re:Try PostgreSQL 9.5 by hajrice on Sunday July 05, 2015 @01:46AM (#9832607)
Anyone know if there's any major upgrades re. speed? From 9.0 to 9.5?
Re:Try PostgreSQL 9.5 by anarazel on Sunday July 05, 2015 @05:06AM (#9832990)
There have been significant scalability improvements in that time (9.2, 9.5). There also have been lots of smaller improvements in single threaded performance in general, leading to rather noticeable aggregate improvements.

That's all for the cases where the same query plan is used in 9.0 and 9.5 - the differences where new type of plans (say index only scans) are often very large.

In short: yes.

Re:Try PostgreSQL 9.5 by davyjones on Sunday July 05, 2015 @02:29AM (#9832710)
Off the top of my head, Index only scans, overhauled GIN & GiST indices, Trigrams come to mind.
Re:Try PostgreSQL 9.5 by brobinson on Sunday July 05, 2015 @08:04AM (#9833259)
9.5 was supposed to get "parallel sequential scan" (which is a big deal performance-wise), but I don't see it on the "what's new in pg 9.5" page. Anyone know what's up with that?
Re:Try PostgreSQL 9.5 by anarazel on Sunday July 05, 2015 @08:52AM (#9833365)
It wasn't ready yet. A significant amount of development happened after the point where that's supposed to happen for features to be integrated in 9.5.

Now that 9.5 has its own branch I hope we'll get it in early in the 9.6 development cycle; so we have time to iron out all the potential kinks.

I don't think there ever was a clear "this will be in 9.5" statement from anyone?

Re:Try PostgreSQL 9.5 by brobinson on Sunday July 05, 2015 @09:59AM (#9833571)
9.5 was the target according to this: http://rhaas.blogspot.com/2015/03/parallel-sequential-scan-f...

Thanks for the info.