RE: BUG #15067: Documentation or behaviour bug with autovacuum thresholds?

From: Greg Clough <greg(dot)clough(at)ipreo(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #15067: Documentation or behaviour bug with autovacuum thresholds?
Date: 2018-02-26 09:04:43
Message-ID: MWHPR03MB3133F06305B276A376992A5DF7C10@MWHPR03MB3133.namprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Even stranger, is that if you do an update of exactly the threshold, wait, and then do a *SINGLE* row update:

I realise this isn't a top priority, but it does seem to allow a violation of the "autovacuum_vacuum_threshold" parameter. In practice it doesn't seem to be serious, but finding the issue would reduce autovacuuming of tables that make exactly (rows * autovacuum_vacuum_threshold + autovacuum_vacuum_threshold) changes.

I presume it's that simple, but I worry it has wider implications.

Cheers,
Greg.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-02-26 10:30:50 BUG #15089: Complete details
Previous Message David G. Johnston 2018-02-26 01:20:13 Re: BUG #15088: Can create subquery with duplicate column names