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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
