Re: Tablespaces - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Tablespaces
Date
Msg-id 40455280.4010305@familyhealth.com.au
Whole thread Raw
In response to Tablespaces  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
> I've been looking at implementing table spaces for 7.5. Some notes and
> implementation details follow.

Ah sorry, other things you might need to consider:

Privileges on tablespaces:

GRANT USAGE ON TABLESPACE tbsp TO ...;

Different disk settings for different tablespaces (since they will 
likely be on different disks):

ALTER TABLESPACE tbsp SET random_page_cost TO 2.5;

Chris




pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Tablespaces
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [ADMIN] Schema comparisons