Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F0DEF650EC8; Fri, 27 Jun 2008 11:25:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45540-03; Fri, 27 Jun 2008 11:25:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from oxford.xeocode.com (87-127-95-194.no-dns-yet.enta.net [87.127.95.194]) by postgresql.org (Postfix) with ESMTP id 8E577650EC0; Fri, 27 Jun 2008 11:25:53 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.69) (envelope-from ) id 1KCEtY-0002dg-JI; Fri, 27 Jun 2008 15:25:48 +0100 To: "Alvaro Herrera" Cc: "Simon Riggs" , "Tom Lane" , "pgsql-hackers" , "List pgsql-patches" Subject: Re: [HACKERS] Hint Bits and Write I/O In-Reply-To: <20080618143212.GE5077@alvh.no-ip.org> (Alvaro Herrera's message of "Wed\, 18 Jun 2008 10\:32\:12 -0400") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.patches" 5093) References: <1211916951.4489.232.camel@ebony.site> <15901.1211931165@sss.pgh.pa.us> <1213797209.9468.126.camel@ebony.site> <20080618143212.GE5077@alvh.no-ip.org> From: Gregory Stark Organization: EnterpriseDB Date: Fri, 27 Jun 2008 15:25:47 +0100 Message-ID: <87lk0rq7is.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/192 X-Sequence-Number: 6678 "Alvaro Herrera" writes: > If only VACUUM is going to set "flexible" to off, maybe it's better to > leave the APIs as they are and have a global that's set by VACUUM only > (and reset in a PG_CATCH block). Ugh. Perhaps it would be simpler to have a wrapper function HTSV() macro which passes flexible=true to HTSV_internal(). Then vacuum can call HTSV_internal(). I'm not sure what the performance tradeoff is between having an extra argument to HTSV and having HTSV check a global which messes with optimizations. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!