Tom Lane <t...@sss.pgh.pa.us> > Another point here is that you could get some of the hoped-for > benefit just by increasing BLCKSZ ... but nobody's ever > demonstrated any compelling benefit from larger BLCKSZ (except on > specialized workloads, if memory serves).
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. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
