Re: autovacuum not prioritising for-wraparound tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: autovacuum not prioritising for-wraparound tables
Date: 2013-02-03 16:17:42
Message-ID: 8033.1359908262@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> It obviously needs more polish:

> - I opted for using the 64bit representation of xids, seems to be better
> in a log which very well might be looked at only after some
> wraparounds
> - exporting 'txid' from adt/txid.c is pretty ugly. I don't like the
> invention of the type in general, but making it visible outside of
> txid.c is even uglier, but using both, plain uint64 and txid inside
> txid.c isn't nice either.
> - txid_from_xid should be renamed, don't have a good idea to what right
> now.
> - is there agreement on the additionally logged information?

-1 on using txids here. If memory serves, we have had exactly this
discussion before and rejected spreading those into other parts
of the system. That gets rid of three of your problems right there,
as well as a lot of ugly hackery with UINT64_FORMAT.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-02-03 16:41:20 Re: autovacuum not prioritising for-wraparound tables
Previous Message Dean Rasheed 2013-02-03 15:04:48 Re: missing rename support