Controlling Table/Index Location - Mailing list pgsql-admin

From Jeff Young
Subject Controlling Table/Index Location
Date
Msg-id uCbN7.83237$lV4.9677598@e420r-atl1.usenetserver.com
Whole thread Raw
List 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






pgsql-admin by date:

Previous
From: Vincent.Gaboriau@answare.fr
Date:
Subject: Re: [HACKERS] upper and lower doesn't work with german
Next
From: "news.i-2000.com"
Date:
Subject: Re: Clustering high-availability