Re: Autovacuum versus rolled-back transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum versus rolled-back transactions
Date: 2007-06-01 01:19:28
Message-ID: 15412.1180660768@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> If we apply Heikki's idea of advancing OldestXmin, I think what we
> should do is grab the value from pgstats when vacuum starts, and each
> time we're going to advance OldestXmin, grab the value from pgstats
> again; accumulate the differences from the various pgstat grabs. At the
> end we send the accumulated differences as the new dead tuple count.

Considering that each of those values will be up to half a second old,
I can hardly think that this will accomplish anything except to
introduce a great deal of noise ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2007-06-01 02:08:01 Re: table partitioning pl/pgsql helpers
Previous Message ITAGAKI Takahiro 2007-06-01 01:08:27 Re: Autovacuum versus rolled-back transactions