pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John Arbash Meinel <john@arbash-meinel.com>
To: pgsql-performance@postgresql.org
Subject: Re: fine tuning for logging server
Date: Wed, 30 Mar 2005 20:34:39 -0600
Message-ID: <424B61BF.3010906@arbash-meinel.com> (raw)
In-Reply-To: <1112235878.12159.22.camel@stantz.corp.sgi.com>
References: <1112233809.10313.31.camel@stantz.corp.sgi.com>
	<424B5982.3090809@arbash-meinel.com>
	<1112235878.12159.22.camel@stantz.corp.sgi.com>

Florin Andrei wrote:

>On Wed, 2005-03-30 at 19:59 -0600, John Arbash Meinel wrote:
>
>
>
>>Put pg_xlog onto the same drive as the OS, not the drive with the database.
>>
>>
>
>I forgot to mention: the OS drive is purposefully made very slow - the
>write cache is turned off and the FS is Ext3 with data=journal. Is then
>still ok to put pg_xlog on it?
>
>The reason: if the power cord is yanked, the OS _must_ boot back up in
>good condition. If the DB is corrupted, whatever, nuke it then re-
>initialize it. But the OS must survive act-of-god events.
>
>No, there is no uninterruptible power supply. It sucks, but that's how
>it is. I cannot change that.
>
>
>
You don't want write cache for pg_xlog either. And you could always
create a second partition that used reiserfs, or something like that.

If you have to survine "act-of-god" you probably should consider making
the system into a RAID1 instead of 2 separate drives (software RAID
should be fine).

'Cause a much worse act-of-god is having a drive crash. No matter what
you do in software, a failed platter will prevent you from booting. RAID
1 at least means 2 drives have to die.

If you need insert speed, and can't do custom transactions at the
application side, you could try creating a RAM disk for the insert
table, and then create a cron job that bulk pulls it out of that table
and inserts it into the rest of the system. That should let you get a
super-fast insert speed, and the bulk copies should stay reasonably fast.

Just realize that if your cron job stops running, your machine will
slowly eat up all of it's ram, and really not play nice. I think adding
an extra hard-drive is probably the best way to boost performance and
reliability, but if you have a $0 budget, this is a possibility.

John
=:->

Attachments:

  signature.asc (application/pgp-signature, 252B) download

view thread (10+ messages)  latest in thread

Message-ID: <424B61BF.3010906@arbash-meinel.com>
Permalink:  ../424B61BF.3010906@arbash-meinel.com/
Also on:    postgresql.org/message-id/424B61BF.3010906@arbash-meinel.com

 · 

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: john@arbash-meinel.com
  Subject: Re: fine tuning for logging server
  In-Reply-To: <424B61BF.3010906@arbash-meinel.com>

* 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