Make autovacuum sort tables in descending order of xid_age

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Cc: Christophe Pettus <xof(at)thebuild(dot)com>
Subject: Make autovacuum sort tables in descending order of xid_age
Date: 2019-11-29 18:01:39
Message-ID: 20191129180138.GD8731@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

Per a suggestion Christophe made, please find attached a patch to
$Subject:

Apart from carefully fudging with pg_resetwal, and short of running in
production for a few weeks, what would be some good ways to test this?

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Attachment Content-Type Size
v1-0001-Autovacuum-tables-in-descending-order-of-age.patch text/x-diff 4.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2019-11-29 21:57:24 Re: checkpointer: PANIC: could not fsync file: No such file or directory
Previous Message Masahiko Sawada 2019-11-29 17:44:58 Using XLogFileNameP in critical section