| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | 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>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Has anybody think about changing BLCKSZ to an option of initdb? |
| Date: | 2009-03-14 15:45:50 |
| Message-ID: | 1237045550.29094.1.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, 2009-03-14 at 15:29 +0000, Gregory Stark wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> > I think that is an understatement. I would say 99% of postgresql users
> > do NOT compile from source. Heck the only time I compile from source is
> > when I need to fix mis-configured defaults in RH packages (which is why
> > we now have rpms that fix those defaults) or when we have back patched
> > something for a customer.
>
> 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.
Joshua D. Drake
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
> Ask me about EnterpriseDB's RemoteDBA services!
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-03-14 15:47:24 | Re: Has anybody think about changing BLCKSZ to an option of initdb? |
| Previous Message | Gregory Stark | 2009-03-14 15:29:44 | Re: Has anybody think about changing BLCKSZ to an option of initdb? |