Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CDAE0632CA2 for ; Tue, 24 Aug 2010 10:33:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 15641-05 for ; Tue, 24 Aug 2010 13:32:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 66279632998 for ; Tue, 24 Aug 2010 10:32:56 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id o7ODWbC19866; Tue, 24 Aug 2010 09:32:37 -0400 (EDT) From: Bruce Momjian Message-Id: <201008241332.o7ODWbC19866@momjian.us> Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this? In-Reply-To: <201008231924.o7NJOL616202@momjian.us> To: Bruce Momjian Date: Tue, 24 Aug 2010 09:32:37 -0400 (EDT) CC: Tom Lane , Alvaro Herrera , Josh Berkus , PostgreSQL-development X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/1693 X-Sequence-Number: 168496 Applied. --------------------------------------------------------------------------- Bruce Momjian wrote: > Tom Lane wrote: > > Bruce Momjian writes: > > > OK, I have attached a proposed patch to improve this. I moved the > > > pg_clog mention to a new paragraph and linked it to the reason the > > > default is relatively low. > > > > The references to "vacuum freeze" are incorrect; autovacuum does NOT > > do the equivalent of VACUUM FREEZE. Please stop playing around with > > the perfectly good existing wording. > > Uh, so VACUUM FREEZE unconditionally freezes all rows, while vacuum just > freezes rows who's xid is older than vacuum_freeze_min_age? I saw that > in our current docs in reference to VACUUM FREEZE: > > Selects aggressive "freezing" of tuples. Specifying FREEZE is > equivalent to performing VACUUM with the vacuum_freeze_min_age > parameter set to zero. The FREEZE option is deprecated and > will be removed in a future release; set the parameter instead. > > Updated patch attached. > > -- > Bruce Momjian http://momjian.us > EnterpriseDB http://enterprisedb.com > > + It's impossible for everything to be true. + > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +