Re: Hot features for 9.5 beta - Mailing list pgsql-advocacy

From Michael Paquier
Subject Re: Hot features for 9.5 beta
Date
Msg-id CAB7nPqS=Sx6JAwiA=N7MuHh6=ADce42hUp0nsUvAV+izqfW_dg@mail.gmail.com
Whole thread Raw
In response to Re: Hot features for 9.5 beta  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List pgsql-advocacy
On Fri, Jun 12, 2015 at 6:54 AM, Petr Jelinek
<petr.jelinek@2ndquadrant.com> wrote:
> On Thu, Jun 11, 2015 at 11:05 , Josh Berkus <josh@agliodbs.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


pgsql-advocacy by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Hot features for 9.5 beta
Next
From: Sameer Kumar
Date:
Subject: Re: Hot features for 9.5 beta