Re: I/O on select count(*)

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: I/O on select count(*)
Date: 2008-05-15 05:20:11
Message-ID: 482BC80B.3010109@wildenhain.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-05-15 07:02:19 Re: I/O on select count(*)
Previous Message Joshua D. Drake 2008-05-15 03:13:30 Re: I/O on select count(*)