| From: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Gregory Stark <stark(at)enterprisedb(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jacky Leng <lengjianquan(at)163(dot)com>, jd(at)commandprompt(dot)com |
| Subject: | Re: Has anybody think about changing BLCKSZ to an option of initdb? |
| Date: | 2009-03-16 04:24:46 |
| Message-ID: | 20090316130321.ABB7.52131E4D@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Joshua D. Drake" <jd(at)commandprompt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KaiGai Kohei | 2009-03-16 05:05:47 | Re: Updates of SE-PostgreSQL 8.4devel patches (r1710) |
| Previous Message | Bruce Momjian | 2009-03-16 02:56:19 | Re: Updates of SE-PostgreSQL 8.4devel patches (r1710) |