Re: ext3 block size

From: Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au>
To: DeJuan Jackson <djackson(at)speedfc(dot)com>
Cc: "Wilson A(dot) Galafassi Jr(dot)" <juniorlist(at)yahoo(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: ext3 block size
Date: 2003-08-07 00:56:36
Message-ID: 1060217795.21673.9.camel@ws12.commsecure.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2003-08-07 at 09:47, DeJuan Jackson wrote:
> Don't know the answer to your question, but I thought I would just
> pipe in and say that if this is an SMP (has multiple processors) Linux
> box you don't want to use ext3!!!
>
> I used ext3 on my SMP box here at work and now I can't have children
> (I guess it would help if I got a wife first)!!
> But in all seriousness SMP + ext3 = BAD(unpredictable crashes
> depending loosely related to system load).
>
>
> Wilson A. Galafassi Jr. wrote:
> > hello.
> > my database size is 5GB. what is the block size recommend?
> > thanks
> > wilson
> >

We have about 14 dual-CPU Athlon and PIII machines here, all using ext3,
all with lots of use (3 of them average >100 db queries/second for
several hours for example).

No problems. We were getting lots of crashes under 2.4.x where x<12, but
that's ancient history, and only on the Athlons.

Stephen

--
Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au>
CommSecure Australia Pty Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-08-07 02:03:40 Re: ext3 block size
Previous Message Bruce Momjian 2003-08-07 00:40:38 Re: Could not receive data from server