5 ms·
For the juicy stuff, here's the list of what's new in 9.5: https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5 https://wiki.postgresql.org/wiki/Wha
by pjscott 11y ago
For the juicy stuff, here's the list of what's new in 9.5:
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5 https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_...
- mason55 11y agoI haven't been following super closely but it looks like parallel sequential scan didn't make it in?
- elchief 11y agoThat was a 9.6 feature all along
- DrJokepu 11y agoI think the original ambition was to release it in 9.5 [0], but then it was delayed and rescheduled for 9.6 [1]. [0]: http://rhaas.blogspot.co.uk/2015/03/parallel-sequential-scan-for-postgresql.html http://rhaas.blogspot.co.uk/2015/03/parallel-sequential-scan... [1]: http://rhaas.blogspot.co.uk/2015/11/parallel-sequential-scan-is-committed.html http://rhaas.blogspot.co.uk/2015/11/parallel-sequential-scan...
- davidw 11y agoI wonder if "GROUPING SETS, CUBE and ROLLUP" can be employed to easily do groupwise maximum type queries. I always have to look those up each time I come back to them.
- dragonwriter 11y agoAren't MAX() and GROUP BY enough for that?
- buro9 11y agoYou could do it without, but these shorthand expressions make it very simple to do it quickly and do it right.
- dragonwriter 11y agoBut groupwise maximum by some expression is exactly SELECT MAX(expression) GROUP BY (criteria). You could do details and groupwise maximums together with ROLLUP and some grouping-based conditional expressions in the SELECT clause, or just by UNIONing a detail query with the groupies maximums.