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

From David Steele
Subject Re: Make autovacuum sort tables in descending order of xid_age
Date
Msg-id 2e45935a-d492-2b19-a2c4-991e1efe0895@pgmasters.net
Whole thread Raw
In response to Re: Make autovacuum sort tables in descending order of xid_age  (David Fetter <david@fetter.org>)
Responses Re: Make autovacuum sort tables in descending order of xid_age  (Mark Dilger <mark.dilger@enterprisedb.com>)
List pgsql-hackers
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?

-- 
-David
david@pgmasters.net



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Improving connection scalability: GetSnapshotData()
Next
From: "Jonathan S. Katz"
Date:
Subject: PostgreSQL 13 Feature Freeze + Release Management Team (RMT)