pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron Johnson <ron.l.johnson@cox.net>
To: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Tuning PostgreSQL
Date: 22 Jul 2003 10:36:30 -0500
Message-ID: <1058888190.15449.94.camel@haggis> (raw)
In-Reply-To: <00d301c35062$25c943b0$b696a8c0@APR>
References: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com>
	<014a01c34f90$74bc2c80$b696a8c0@APR>
	<200307210906.10226.josh@agliodbs.com>
	<20030721162852.GN19009@md2.mediadesign.nl>
	<002901c3501f$86565940$b696a8c0@APR>
	<20030722094035.GU19009@md2.mediadesign.nl>
	<009901c35054$fad824d0$b696a8c0@APR>
	<20030722143335.GH55392@nasby.net>
	<00d301c35062$25c943b0$b696a8c0@APR>

On Tue, 2003-07-22 at 10:01, Alexander Priem wrote:
> OK, another change of plans :)
> 
> ext2 seems to be a bad idea. So i'll stick with ext3. Better safe than
> sorry...

Don't forget noatime!

> About the RAID-config: Maybe RAID-10 with six disks is affordable after all.
> I would have to take the smallest disks in this case, 18Gb per disk. So six
> 18Gb disks (15000rpm) would result in a total capacity of 54 Gb, right? This
> volume would hold OS, WAL and data, but since RAID10 appears to deliver such
> great performance (according to several people), in combination with the
> 128Mb of battery backed cache, this would be a good solution?
> 
> Hmmm. I keep changing my mind about this. My Db would be mostly 'selecting',
> but there would also be pretty much inserting and updating done. But most of
> the work would be selects. So would this config be OK?

Others may disagree, but I'd put the OS and executables on a separate
disk from the db and WAL, and make it an IDE drive, since it's so 
much less expensive than SCSI disks.  (Make a copy of the disk, and
if it craps out, pop out the old disk, stick in the new disk, and
fire the box right back up...)

Thus, you'll have an OS/executables disk, and a separate DB disk,
and never the twain shall meet.  Theoretically, you could pick up
those 6 drives and controller, move them to another machine, and
the data should be just as it was on the other box.

-- 
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+





view thread (47+ messages)  latest in thread

Message-ID: <1058888190.15449.94.camel@haggis>
Permalink:  ../1058888190.15449.94.camel@haggis/
Also on:    postgresql.org/message-id/1058888190.15449.94.camel@haggis

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ron.l.johnson@cox.net
  Subject: Re: Tuning PostgreSQL
  In-Reply-To: <1058888190.15449.94.camel@haggis>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox