Josh Berkus wrote:
> However, at Greenplum I remember determining that larger PG block sizes,
> if matched with larger filesystem block sizes did significantly help on
> performance of data warehouses which do a lot of seq scans -- but that
> our ceiling of 32K was still too small to really make this work. I
> don't have the figures for that, though; Luke reading this?
And did they study the effect of tuning the kernel's readahead?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support