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

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 (view raw or flat)
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

pgsql-performance by date

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

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