Re: brin autosummarization -- autovacuum "work items"

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: brin autosummarization -- autovacuum "work items"
Date: 2017-03-31 19:29:08
Message-ID: CA+TgmoYk9HEicw9NLEWJYoZspgjtFBp9O=iM6qjqAn7G_5Se5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 21, 2017 at 4:10 PM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2017-03-31 19:31:35 Re: postgres_fdw IMPORT SCHEMA and partitioned tables
Previous Message Robert Haas 2017-03-31 19:25:19 Re: postgres_fdw IMPORT SCHEMA and partitioned tables