From: Tino Wildenhain <tino@wildenhain.de>
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: Thu, 15 May 2008 07:20:11 +0200
Message-ID: <482BC80B.3010109@wildenhain.de> (raw)
In-Reply-To: <C451C651.5EE8B%llonergan@greenplum.com>
References: <C451C651.5EE8B%llonergan@greenplum.com>
Hi,
Luke Lonergan 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.
can you go a bit deeper into how you implemented this or is it some IP
of greenplum you cannot reveal?
Btw, is there something with your eyes:
<FONT SIZE="4"><FONT FACE="Verdana, Helvetica, Arial"><SPAN
STYLE='font-size:14pt'> ? :-))
Cheers
Tino
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) 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: tino@wildenhain.de, llonergan@greenplum.com, pavan.deolasee@gmail.com, gsmith@gregsmith.com, alvherre@commandprompt.com
Subject: Re: I/O on select count(*)
In-Reply-To: <482BC80B.3010109@wildenhain.de>
* 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