Re: brin autosummarization -- autovacuum "work items"
От
Alvaro Herrera
Тема
Re: brin autosummarization -- autovacuum "work items"
Дата
Msg-id
20170401170601.jpqar6gzw42uzhql@alvherre.pgsql
Ответ на
Re: brin autosummarization -- autovacuum "work items" (Robert Haas)
Список
Robert Haas wrote: > On Tue, Mar 21, 2017 at 4:10 PM, Alvaro Herrera > 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
Дата: