| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Chris Ruprecht <chrup(at)earthlink(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: ProstGreSQL on RAID Question |
| Date: | 2002-08-12 03:30:42 |
| Message-ID: | Pine.NEB.4.44.0208121228540.2317-100000@angelic.cynic.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Mungall | 2002-08-12 04:01:40 | Re: abnormally long time in performing a two-table join |
| Previous Message | Chris Mungall | 2002-08-12 01:54:37 | Re: abnormally long time in performing a two-table join |