Re: Return of the Solaris vacuum polling problem -- anyone remember this?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this?
Date: 2010-08-18 19:53:31
Message-ID: 4C6BF3EB0200002500034887@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:

>> This is an anti-wraparound vacuum, so it could have something to
>> do with the hint bits. Maybe it's setting the freeze bit on
>> every page, and writing them one page at a time?
>
> That would explain all the writes, but it doesn't seem to explain
> why your two servers aren't behaving similarly.

One was bulk-loaded from the other, or they were bulk-loaded at
different times? Or one had some other activity that boosted the
xid count, possibly in another database?

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-08-18 19:55:47 Re: patch: utf8_to_unicode (trivial)
Previous Message Tom Lane 2010-08-18 19:23:02 Re: trace_recovery_messages