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