Re: Tablespaces - Mailing list pgsql-general

From Ray Stell
Subject Re: Tablespaces
Date
Msg-id 20070604123152.GJ12941@cns.vt.edu
Whole thread Raw
In response to Tablespaces  (John Gardner <john.gardner@tagish.co.uk>)
List pgsql-general
On Mon, Jun 04, 2007 at 09:49:03AM +0100, John Gardner wrote:
> /var/lib/pgsql/data/.  Shall I just create a directory under here and
> point the tablespace to there?  Any advice would be appreciated.

One of the points of ts is to balance io over different controllers/disks.
Someone should evalulate the current load and overlay the estimated
load of the new app and see if the current data path will support it.
Include growth estimates for all the apps.  If the load is a concern,
create the ts on a seperate io path.  What are the possible results of
not doing this analysis?

pgsql-general by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: multimaster
Next
From: Andrew Sullivan
Date:
Subject: Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]