Re: Make autovacuum sort tables in descending order of xid_age

From: Mark Dilger <hornschnorter(at)gmail(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: 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: 2019-12-12 22:30:47
Message-ID: 7f72ef60-b2a1-4a9f-b3f5-b6e1d4f85df1@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/12/19 1:35 PM, Mark Dilger wrote:
> Once the xid age reaches one
> million, it will start to be the dominant factor.

Actually, it doesn't change much from x = 1 to x = 1,000,000
but I was planning to add another factor to the formula and
forgot before sending the email. I'll leave that as an
exercise for the reader.

--
Mark Dilger

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2019-12-12 22:32:52 Re: log bind parameter values on error
Previous Message Peter Geoghegan 2019-12-12 22:06:03 Re: Remove configure --disable-float4-byval and --disable-float8-byval