Best use of second controller with faster disks?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Best use of second controller with faster disks?
Date: 2007-06-12 01:14:43
Message-ID: cone.1181610883.141260.28905.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Configuration
OS: FreeBSD 6.1 Stable
Postgresql: 8.1.4

RAID card 1 with 8 drives. 7200 RPM SATA RAID10
RAID card 2 with 4 drives. 10K RPM SATA RAID10

Besides having pg_xlog in the 10K RPM drives what else can I do to best use
those drives other than putting some data in them?

Iostat shows the drives getting used very little, even during constant
updates and vacuum.

Some of the postgresl.conf settings that may be relevant.
wal_buffers = 64
checkpoint_segments = 64

If nothing else I will start to put index files in the 10K RPM RAID.

As for the version of postgreql.. we are likely getting a second
machine, break off some of the data, change programs to read data from both
and at some point when there is little data in the 8.1.4, upgrade the 8.1.4
machine. The new machine will have 8.2.4

We have a lot of historical data that never changes which is the main
driving factor behind looking to split the database into current and
historical.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christo Du Preez 2007-06-12 06:36:28 Re: test / live environment, major performance difference
Previous Message Ed Tyrrill 2007-06-12 01:09:46 Re: Best way to delete unreferenced rows?