Re: ProstGreSQL on RAID Question - Mailing list pgsql-admin

From nikolaus@dilger.cc
Subject Re: ProstGreSQL on RAID Question
Date
Msg-id 20020828163139.18649.h016.c001.wm@mail.dilger.cc.criticalpath.net
Whole thread Raw
In response to ProstGreSQL on RAID Question  (Chris Ruprecht <chrup@earthlink.net>)
List pgsql-admin
Chris,

You should be fine.

For each Postgres block you are reading 2 OS blocks.
That's fine.  The other way around would be bad.

The optimal RAID block size depends on things like read
 ahead algorithms for large sequential reads.

If it ain't broke, don't fix it.

Regards,
Nikolaus Dilger


On Fri, 16 August 2002, Chris Ruprecht wrote:

>
> Thanks Curt - yes, I have the log files on a different
> drive all together.
> I was thinking more along the lines of OS block size
(4
> KB) vs. Postgres block
> size (8 KB by default) vs. RAID block size (32 KB). Is
> there anything I
> should change?
>
> I would like to experiment but a 20 GB DB takes some
> time to backup and
> restore, so I'd like to tap into other's experiences.
>
> Best regards,
> Chris
>
>
>
> On Sun August 11 2002 23:30, you wrote:
> > On Mon, 12 Aug 2002, Chris Ruprecht wrote:
> > > I have set up a RAID-5 (soft RAID) arrray
on my
> Linux machine,
> > > consisting of 5 18 GB UltraSCSI-2 (80
MB/sec)
> drives. Everythinng is
> > > working but I would like to know, where I
can tweak
> this for optimum
> > > performance.
> >
> > If you do a lot of inserts, move the log file
> ($PGDATA/pg_xlog)
> > off the RAID-5 and on to a separate RAID-1
(mirrored)
> pair. This will
> > separate the buffered random writes to the data
files
> and the unbuffered,
> > sequential writes to the log.
> >
> > cjs
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send
> an appropriate
> subscribe-nomail command to majordomo@postgresql.org
so
> that your
> message can get through to the mailing list cleanly

pgsql-admin by date:

Previous
From: nikolaus@dilger.cc
Date:
Subject: Re: Performance Problems
Next
From: "shreedhar"
Date:
Subject: How can I Delete/Alter Unique Constraint