"Joshua D. Drake" <j...@commandprompt.com> wrote: > > So has anyone here done any experiments with live systems with different > > block > > sizes? What were your experiences? > > I tested with 4k once. The system tanked. This might be a good one for > the performance lab.
I'm using 16k blocks for one system. There are tables with 5kB+/row. The perfomance was worst if 8kB blocks because of many TOASTed fields and unusable spaces. There are some users who don't want to recompile postgres because they think recompiled version of postgres are not tested well and not supported by companies and 3rd party tools. Their database designs are bad, of course, but they want to resolve their problem using knobs of databases. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
