Re: Does larger i/o size make sense?

Kevin,

> I think I've seen a handful of reports of performance differences
> with different BLCKSZ builds (perhaps not all on community lists). 
> My recollection is that some people sifting through data in data
> warehouse environments see a performance benefit up to 32KB, but
> that tests of GiST index performance with different sizes showed
> better performance with smaller sizes down to around 2KB.

I believe that Greenplum currently uses 128K.  There's a definite
benefit for the DW use-case.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com