Controlling Table/Index Location

From: "Jeff Young" <jeff(at)muttworks(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Controlling Table/Index Location
Date: 2001-11-28 20:20:41
Message-ID: uCbN7.83237$lV4.9677598@e420r-atl1.usenetserver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am aware of the initlocation command that allows me to set up a new
directory location for a database

CREATE DATABASE xxx WITH LOCATION = 'xxx';

I am interested a finer level of control for performance reasons.
Specifying that this table belongs on this disk pack whiles it corresponding
index belongs on this disk pack may be useful for performance tuning.

CREATE TABLE xxx ....
WITH LOCATION =

CREATE INDEX xxx ...
WITH LOCATION =

I though maybe I could do it using the File System Links but the data
directories seem to be grouped in the numbers that do not correspond to the
oid from the pg_types table...

Any Idease on this one are appreciated.

Jeff Young

Browse pgsql-admin by date

  From Date Subject
Next Message Leong, Fushan 2001-11-28 22:56:45 how often should I run Vacuum
Previous Message news.i-2000.com 2001-11-28 19:51:04 Re: Clustering high-availability