Re: Recalculating OldestXmin in a long-running vacuum - Mailing list pgsql-patches

From Heikki Linnakangas
Subject Re: Recalculating OldestXmin in a long-running vacuum
Date
Msg-id 46094FED.4010508@enterprisedb.com
Whole thread Raw
In response to Re: Recalculating OldestXmin in a long-running vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Recalculating OldestXmin in a long-running vacuum
Re: Recalculating OldestXmin in a long-running vacuum
List pgsql-patches
Tom Lane wrote:
> Heikki Linnakangas <heikki@enterprisedb.com> writes:
>> Bruce Momjian wrote:
>>> So are you stopping work on the patch?  I assume so.
>
>> Yes, at least for now. I can't believe the patch actually hurts
>> performance, but I'm not going to spend time investigating it.
>
> Are we withdrawing the patch from consideration for 8.3 then?
> I had assumed it was still a live candidate, but if it seems to
> lose in pgbench maybe we had better set it aside.

I haven't tried pgbench, the tests I ran were with DBT-2.

Just to summarize again: the patch did help to keep the stock table
smaller, but the response times were higher with the patch.

Maybe we should keep this issue open until we resolve the vacuum WAL
flush issue? I can then rerun the same tests to see if this patch is a
win after that.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recalculating OldestXmin in a long-running vacuum
Next
From: Bruce Momjian
Date:
Subject: Re: Recalculating OldestXmin in a long-running vacuum