Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group