Re: Make autovacuum sort tables in descending order of xid_age - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: Make autovacuum sort tables in descending order of xid_age
Date
Msg-id 019573E6-B914-4FD4-A46B-AD727CF500AF@enterprisedb.com
Whole thread Raw
In response to Re: Make autovacuum sort tables in descending order of xid_age  (David Steele <david@pgmasters.net>)
Responses Re: Make autovacuum sort tables in descending order of xid_age  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers

> On Mar 30, 2020, at 7:09 AM, David Steele <david@pgmasters.net> wrote:
>
> On 1/11/20 12:53 PM, David Fetter wrote:
>> I agree that it's a complex situation, and that many different
>> approaches will eventually need to be brought to bear.
>> What concerns me about introducing a big lump of complexity here is
>> disentangling the effects of each part and of their interaction terms.
>> We're not, to put it mildly, set up to do ANOVA
>> (https://en.wikipedia.org/wiki/Analysis_of_variance ) , ANCOVA (
>> https://en.wikipedia.org/wiki/Analysis_of_covariance ), etc. on
>> changes.
>> Given the above, I'd like to make the case for changing just this one
>> thing at first and seeing whether the difference it makes is generally
>> positive.
>
> Mark, Robert, thoughts on this?

I have not been working on this issue lately, but as I recall, my concern was that changing the behavior of autovacuum
couldintroduce regressions for some users, so we should be careful to get it right before we rush to release anything.
Itdidn't seem like the proposed changes took enough into account.  But that's clearly a judgement call, having to do
withhow cautious any particular person thinks we should be.  I don't feel strongly enough to stand in the way if the
generalconcensus is that this is a good enough implementation. 

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company






pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ALTER TABLE ... SET STORAGE does not propagate to indexes
Next
From: Adam Brusselback
Date:
Subject: Re: ALTER TABLE ... SET STORAGE does not propagate to indexes