Re: I/O on select count(*) - Mailing list pgsql-performance

From Tino Wildenhain
Subject Re: I/O on select count(*)
Date
Msg-id 482BC80B.3010109@wildenhain.de
Whole thread Raw
In response to Re: I/O on select count(*)  (Luke Lonergan <llonergan@greenplum.com>)
List 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


Attachment

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: I/O on select count(*)
Next
From: Tom Lane
Date:
Subject: Re: I/O on select count(*)