Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 66197650F13; Fri, 27 Jun 2008 11:49:45 -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 70743-01; Fri, 27 Jun 2008 11:49:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137179.authsmtp.com (outmail137179.authsmtp.com [62.13.137.179]) by postgresql.org (Postfix) with ESMTP id CA5D3650F25; Fri, 27 Jun 2008 11:49:28 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5REnM2b076942; Fri, 27 Jun 2008 15:49:22 +0100 (BST) Received: from [192.168.0.3] (85-211-229-155.dyn.gotadsl.co.uk [85.211.229.155]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5REnDat055472; Fri, 27 Jun 2008 15:49:13 +0100 (BST) Subject: Re: [HACKERS] Hint Bits and Write I/O From: Simon Riggs To: Gregory Stark Cc: Alvaro Herrera , Tom Lane , pgsql-hackers , List pgsql-patches In-Reply-To: <87lk0rq7is.fsf@oxford.xeocode.com> 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> <87lk0rq7is.fsf@oxford.xeocode.com> Content-Type: text/plain Date: Fri, 27 Jun 2008 15:53:56 +0100 Message-Id: <1214578436.3845.413.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 35e155da-4458-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacxtFagJbZ0xf HGQLW1xEUVh7XWp/ ag4fZQBDYEtPQQdo WVZIR1dNFgBqBAMB SEMbMGwsA1QCeHt1 YUFgEHFeVEc0dkMo Q0tRQTwbYWNlYH0e URQMagtVdQZXfh9E a1h6AHAKZjZWKBg1 TUcAHxkaHhhlExEd YgALMRo4QFoQVjc6 S1g9BzQzEAUkAAJb X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1078/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/194 X-Sequence-Number: 6680 On Fri, 2008-06-27 at 15:25 +0100, Gregory Stark wrote: > "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. Doing this doesn't actually reduce the size of the patch much, as it turns out, so I suggest we don't do this. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support