Re: brin autosummarization -- autovacuum "work items"

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: brin autosummarization -- autovacuum "work items"
Дата
Msg-id 20170401170601.jpqar6gzw42uzhql@alvherre.pgsql
обсуждение исходный текст
Список pgsql-hackers
Robert Haas wrote:
> On Tue, Mar 21, 2017 at 4:10 PM, Alvaro Herrera
> <alvherre@2ndquadrant.com> wrote:
> > Well, the number of work items is currently fixed; but if you have many
> > BRIN indexes, then you'd overflow (lose requests).  By using DSA I am
> > making it easy to patch this afterwards so that an arbitrary number of
> > requests can be recorded.
> 
> But that could also use an arbitrarily large amount of memory, and any
> leaks will be cluster-lifespan.

Good point -- probably not such a great idea as presented.  The patch
only uses a fixed amount of memory currently, so it should be fine on
that front.  I think this is a good enough start.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: gitlab post-mortem: pg_basebackup waiting for checkpoint
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: brin autosummarization -- autovacuum "work items"