Re: Per-tablespace autovacuum settings - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Per-tablespace autovacuum settings
Date
Msg-id CA+TgmoYn0=zXEeR+gjKHGwF8RUWtWTu00qvEJb5DPCiYMwi0rg@mail.gmail.com
Whole thread Raw
In response to Re: Per-tablespace autovacuum settings  (Oleksii Kliukin <alexk@hintbits.com>)
Responses Re: Per-tablespace autovacuum settings
List pgsql-hackers
On Thu, Apr 25, 2019 at 12:36 PM Oleksii Kliukin <alexk@hintbits.com> wrote:
> - Fallbacks to autovacuum parameters in another scope. Right now in the
> absence of the per-table and per-tablespace autovacuum parameters the code
> uses the ones from the global scope. However, if only some of the reloptions
> are set on a per-table level (i.e. none of the autovacuum related ones), we
> assume defaults for the rest of reloptions without consulting the lower
> level (i.e .per-tablespace options). This is so because we don’t have the
> mechanism to tell whether the option is set to its default value (some of
> them use -1 to request the fallback to the outer level, but for some it’s
> not possible, i.e. autovacuum_enabled is just a boolean value).

That sounds like it's probably not acceptable?

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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: error messages in extended statistics
Next
From: Mark Wong
Date:
Subject: Re: Why is infinite_recurse test suddenly failing?