Re: Return of the Solaris vacuum polling problem -- anyone remember this?
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Josh Berkus" <josh@agliodbs.com>,"Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2010-08-18T19:53:31Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote: > Josh Berkus <josh@agliodbs.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