Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table
Дата
Msg-id CANP8+j+xGN7VaaREy0MNMCDiB7+9JpacJs-Kv6tGyZxODwTyeg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
Дерево обсуждения
On 21 December 2015 at 09:35, Peter Geoghegan <pg@heroku.com> wrote:
On Mon, Dec 21, 2015 at 1:24 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Given BRIN's characteristics, such a table design is compelling when the
> table is very large, yet possible only for certain use cases.

You can say the same thing about BRIN itself, of course.


AFAICS, this idea is workable and so I'd say "patches welcome" on it. 

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: Haribabu Kommi
Дата:
Сообщение: Re: Parallel Aggregate
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?