Re: Hot features for 9.5 beta

On Fri, Jun 12, 2015 at 6:54 AM, Petr Jelinek
<petr(dot)jelinek(at)2ndquadrant(dot)com> wrote:
> On Thu, Jun 11, 2015 at 11:05 , Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>>
>> Folks:
>>
>> While it's somewhat indefinite when we will get a beta, I'd like to be
>> prepared by having target messaging on what's cool in 9.5. Here's what
>> I see:
>>
>> Big Data
>> --------
>>
>> This release contains some major "big data" features.
>>
>> * BRIN indexes: skiplist indexes for multi-GB tables.
>> * Grouping Sets and CUBE: OLAP for PostgreSQL.
>> * Faster sorts: sorts on large amounts of text data are up to 5X faster.
>
>
>
> Don't know about hotness in the eyes of the users but some numeric
> aggregates got about twice as fast and we also have sampling.

FPW compression can boost recovery time and server output in I/O
bounded environments, and reduces WAL space by 20/30%. Not sure if
that's hot enough though.
--
Michael