From: Joshua D. Drake <jd@commandprompt.com>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Pavan Deolasee <pavan.deolasee@gmail.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: I/O on select count(*)
Date: Wed, 14 May 2008 20:13:30 -0700
Message-ID: <20080514201330.5293c5bf@jd-laptop> (raw)
In-Reply-To: <C451C651.5EE8B%llonergan@greenplum.com>
References: <2e78013d0805141940x50c3f51u439019e8e592959@mail.gmail.com>
<C451C651.5EE8B%llonergan@greenplum.com>
On Thu, 15 May 2008 10:52:01 +0800
Luke Lonergan <llonergan@greenplum.com> wrote:
> BTW we¹ve removed HINT bit checking in Greenplum DB and improved the
> visibility caching which was enough to provide performance at the
> same level as with the HINT bit optimization, but avoids this whole
> ³write the data, write it to the log also, then write it again just
> for good measure² behavior.
>
> 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.
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
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/donateAttachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, llonergan@greenplum.com, pavan.deolasee@gmail.com, gsmith@gregsmith.com, alvherre@commandprompt.com
Subject: Re: I/O on select count(*)
In-Reply-To: <20080514201330.5293c5bf@jd-laptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox