Re: Tablespaces

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: John Gardner <john(dot)gardner(at)tagish(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tablespaces
Date: 2007-06-04 12:31:52
Message-ID: 20070604123152.GJ12941@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-04 13:19:41 Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]
Previous Message Alexander Staubo 2007-06-04 12:18:47 Re: multimaster