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