Re: 9.5 new features

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: 9.5 new features
Дата
Msg-id 56A34AC8.4090101@2ndquadrant.fr
обсуждение исходный текст
Ответ на Re: 9.5 new features  (John R Pierce <pierce@hogranch.com>)
Ответы Re: 9.5 new features
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: George Neuner
Дата:
Сообщение: Re: long transfer time for binary data
Следующее
От: David Rowley
Дата:
Сообщение: Re: 9.5 new features