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

From: Joseph S <jks(at)selectacast(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Date: 2009-08-28 14:28:51
Message-ID: h78piu$1sce$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-Michel Pouré 2009-08-28 21:02:57 Memory monitoring tool
Previous Message Joseph S 2009-08-28 14:25:10 Re: What exactly is postgres doing during INSERT/UPDATE ?