Re: 9.5 new features

On 01/23/2016 10:28 AM, John R Pierce wrote:
> On 1/23/2016 12:35 AM, Vik Fearing wrote:
>>> >ok, but it doesn't deal with our use case of needing to bulk delete a 6
>> I can't really parse the end of that sentence, but you are correct that
>> BRIN does not help at all with partition dropping.  Think of it more as
>> a Seq Scan optimization.
>
> yeah, it was supposed to say, bulk delete 6 month old data once a week,
> while the database is still under a full production load of new data.
>
> anyways, yeah, BRIN sounds very cool for very large tables with
> relatively stable data.

I have found it particularly efficient when the BRIN index contains all
columns of the table.  Just using it on one or two columns is not a win
over btree.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support