Re: Make autovacuum sort tables in descending order of xid_age

From: David Steele <david(at)pgmasters(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>, Mark Dilger <hornschnorter(at)gmail(dot)com>
Cc: David Fetter <david(at)fetter(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, Christophe Pettus <xof(at)thebuild(dot)com>
Subject: Re: Make autovacuum sort tables in descending order of xid_age
Date: 2020-03-30 14:09:33
Message-ID: 2e45935a-d492-2b19-a2c4-991e1efe0895@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pgmasters(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan S. Katz 2020-03-30 14:18:03 PostgreSQL 13 Feature Freeze + Release Management Team (RMT)
Previous Message Alexander Korotkov 2020-03-30 14:04:00 Re: Improving connection scalability: GetSnapshotData()