Postgres Pro
Downloads
Home   >   mailing lists

Re: brin autosummarization -- autovacuum "work items" - Mailing list pgsql-hackers

From Robert Haas
Subject Re: brin autosummarization -- autovacuum "work items"
Date
Msg-id CA+TgmoYk9HEicw9NLEWJYoZspgjtFBp9O=iM6qjqAn7G_5Se5Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] brin autosummarization -- autovacuum "work items"  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: postgres_fdw IMPORT SCHEMA and partitioned tables
Next
From: Andres Freund
Date:
Subject: Re: postgres_fdw IMPORT SCHEMA and partitioned tables