Re: What exactly is postgres doing during INSERT/UPDATE ?

Joseph Shraibman <jks@selectacast.net>

From: Joseph S <jks@selectacast.net>

To: pgsql-performance@postgresql.org

Date: 2009-08-28T14:28:51Z

Lists: pgsql-performance

Scott Marlowe wrote:

> After that you have to start looking at hardware.  Soimething as
> simple as a different drive for indexes and another for WAL, and
> another for the base tables can make a big difference.
> 
If I have 14 drives in a RAID 10 to split between data tables and 
indexes what would be the best way to allocate the drives for performance?