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

Re: Tuning scenarios (was Changing the default configuration)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning scenarios (was Changing the default configuration)
Date: 2003-02-20 22:33:02
Message-ID: 200302201433.02654.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
Robert,

> > 	1) Location of the pg_xlog for heavy-update databases.
> 
> I see you put this up pretty high on the list. Do you feel this is the
> most important thing you can do? For example, if you had a two drive
> installation, would you load the OS and main database files on 1 disk
> and put the pg_xlog  on the second disk above all other configurations? 

Yes, actually.   On machines with 2 IDE disks, I've found that this can make 
as much as 30% difference in speed of serial/large UPDATE statements.

> Ideally I recommend 3 disks, one for os, one for data, one for xlog; but
> if you only had 2 would the added speed benefits be worth the additional
> recovery complexity (if you data/xlog are on the same disk, you have 1
> point of failure, one disk for backing up)

On the other hand, with the xlog on a seperate disk, the xlog and the database 
disks are unlikely to fail at the same time.  So I don't personally see it as 
a recovery problem, but a benefit.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Robert TreatDate: 2003-02-20 23:35:44
Subject: Re: Tuning scenarios (was Changing the default
Previous:From: Curt SampsonDate: 2003-02-20 11:30:50
Subject: Re: Questions about indexes?

pgsql-hackers by date

Next:From: Brandon Craig RhodesDate: 2003-02-20 23:13:57
Subject: possibly spurious `EXCEPT ... may not refer to other relation...'
Previous:From: Tom LaneDate: 2003-02-20 21:19:21
Subject: Re: Simplifying timezone support

pgsql-advocacy by date

Next:From: Robert TreatDate: 2003-02-20 23:35:44
Subject: Re: Tuning scenarios (was Changing the default
Previous:From: Robert TreatDate: 2003-02-20 16:15:58
Subject: Re: uppercase = lowercase

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