Re: Database Server Tuning - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Database Server Tuning
Date
Msg-id 200403031059.19759.josh@agliodbs.com
Whole thread Raw
In response to Re: Database Server Tuning  (Vivek Khera <khera@kcilink.com>)
List pgsql-performance
Vivek,

> > With large RAID, have you found that having WAL on a seperate array
> > actually
> > boosts performance?   The empirical tests we've seen so far don't seem
> > to
> > support this.
>
> Yes, it was a noticeable improvement.

Do you have any stats?   This would be useful for your talk, as well.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Bulk INSERT performance in 7.4.1
Next
From: Josh Berkus
Date:
Subject: Re: WAL Optimisation - configuration and usage