Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D67242E0035 for ; Thu, 15 May 2008 00:14:15 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50122-07-2 for ; Thu, 15 May 2008 00:13:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id D4A7D2E003A for ; Thu, 15 May 2008 00:13:07 -0300 (ADT) Received: from jd-laptop (cmdalert.com [69.55.229.115]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m4F3Dvrh009703 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 14 May 2008 20:13:58 -0700 Date: Wed, 14 May 2008 20:13:30 -0700 From: "Joshua D. Drake" To: Luke Lonergan Cc: Pavan Deolasee , Greg Smith , Alvaro Herrera , Subject: Re: I/O on select count(*) Message-ID: <20080514201330.5293c5bf@jd-laptop> In-Reply-To: References: <2e78013d0805141940x50c3f51u439019e8e592959@mail.gmail.com> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.4.0 (GTK+ 2.12.9; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/irQgdRw5X/R7kOiMSvc5fAt"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 14 May 2008 20:13:58 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/196 X-Sequence-Number: 30164 --Sig_/irQgdRw5X/R7kOiMSvc5fAt Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Thu, 15 May 2008 10:52:01 +0800 Luke Lonergan wrote: > BTW =C2=AD we=C2=B9ve removed HINT bit checking in Greenplum DB and impro= ved the > visibility caching which was enough to provide performance at the > same level as with the HINT bit optimization, but avoids this whole > =C2=B3write the data, write it to the log also, then write it again just > for good measure=C2=B2 behavior. >=20 > For people doing data warehousing work like the poster, this Postgres > behavior is miserable. It should be fixed for 8.4 for sure > (volunteers?) Donations? You have the code Luke :) Sincerely, Joshua D. Drake P.S. Sorry for the almost bad Star Wars pun. --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate --Sig_/irQgdRw5X/R7kOiMSvc5fAt Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIK6pdATb/zqfZUUQRAiuzAJ9qNxaGHjGIjd1Vdc6eMvGi/5E8IgCgjFxG Sxv3wuC4NZJC5e5k7jbHZ3I= =zUEW -----END PGP SIGNATURE----- --Sig_/irQgdRw5X/R7kOiMSvc5fAt--