pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <andrew@libertyrms.info>
To: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: partitioning os swap data log tempdb
Date: Mon, 24 Feb 2003 07:15:00 -0500
Message-ID: <20030224071500.C20792@mail.libertyrms.com> (raw)
In-Reply-To: <5187C8401CB1D211AB6E00A0C9929D06018326C5@DDV_EXCH>
References: <5187C8401CB1D211AB6E00A0C9929D06018326C5@DDV_EXCH>

On Mon, Feb 24, 2003 at 10:52:55AM +0100, Schaefer, Mario wrote:
> Can i make a similar configuration with PostgreSQL?

Sort of.  PostgreSQL currently does not have a convenient way to
specify where this or that part of the database lives.  As a result,
your best bet is to use RAID 1+0 for the data area, and get the speed
that way.  If you must do it without more hardware, however, you can
manually move some files to other drives and symlink them.  You
_must_ do this while offline, and if the file grows above 1G, the
advantage will be lost.

It is nevertheless a good idea to put your OS, data directory, and
write head log (WAL) on separate disks.  Also, you should make sure
your PostgreSQL logs don't interfere with the database I/O (the OS
disk is probably a good place for them, but make sure you use some
sort of  log rotator.  Syslog is helpful here).

> What is pg_xlog and how important is it?

It's the write ahead log.  Put it on a separate RAID.

> What ist the prefered filesystem (ext2, ext3 or raiserfs)?

Certainly ext2 is not crash-safe.  There've been some reports of
corruption under reiserfs, but I've never had it happen.  There have
been complaints about performance with ext3.  You might want to
investigate XFS, as it was designed for this sort of task.

> We want to use about 20 databases with varios size from 5 MB to 500MB per
> database
> and more selects than inserts (insert/select ratio about 1/10) for fast
> webaccess.

The WAL is less critical in this case, because it is only extended
when you change the data, not when you select.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110




view thread (5+ messages)  latest in thread

Message-ID: <20030224071500.C20792@mail.libertyrms.com>
Permalink:  ../20030224071500.C20792@mail.libertyrms.com/
Also on:    postgresql.org/message-id/20030224071500.C20792@mail.libertyrms.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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: andrew@libertyrms.info
  Subject: Re: partitioning os swap data log tempdb
  In-Reply-To: <20030224071500.C20792@mail.libertyrms.com>
  References: <5187C8401CB1D211AB6E00A0C9929D06018326C5@DDV_EXCH> <20030224071500.C20792@mail.libertyrms.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