Re: Has anybody think about changing BLCKSZ to an option of initdb? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Has anybody think about changing BLCKSZ to an option of initdb?
Date
Msg-id 1237045550.29094.1.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: Has anybody think about changing BLCKSZ to an option of initdb?  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Has anybody think about changing BLCKSZ to an option of initdb?
List pgsql-hackers
On Sat, 2009-03-14 at 15:29 +0000, Gregory Stark wrote:
> "Joshua D. Drake" <jd@commandprompt.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@jabber.postgresql.org  Consulting, Development, Support, Training  503-667-4564 -
http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997
 



pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Has anybody think about changing BLCKSZ to an option of initdb?
Next
From: Tom Lane
Date:
Subject: Re: Has anybody think about changing BLCKSZ to an option of initdb?