Postgres Pro
Downloads
Home   >   mailing lists

Re: What exactly is postgres doing during INSERT/UPDATE ? - Mailing list pgsql-performance

From Joseph S
Subject Re: What exactly is postgres doing during INSERT/UPDATE ?
Date
Msg-id h78piu$1sce$1@news.hub.org
Whole thread Raw
In response to Re: What exactly is postgres doing during INSERT/UPDATE ?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: What exactly is postgres doing during INSERT/UPDATE ?  (Luke Koops <luke.koops@entrust.com>)
List pgsql-performance
Tree view 
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?

pgsql-performance by date:

Previous
From: Joseph S
Date:
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Next
From: Jean-Michel Pouré
Date:
Subject: Memory monitoring tool