Re: Advantage of more than 1 tablespace on 1 disk? - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Advantage of more than 1 tablespace on 1 disk?
Date
Msg-id 2f4958ff0811030314i76ffe0a5u81666574493ba9de@mail.gmail.com
Whole thread Raw
In response to Advantage of more than 1 tablespace on 1 disk?  ("Thom Brown" <thombrown@gmail.com>)
List pgsql-general


what you want in case of the table that gets read a lot, is partition + cluster. 
For table that changes a lot, I don't really know myself either. It is usually trial and error type of scenario for me. (partitioning too, but that depends on what parts are updated and under what conditions, etc).

pgsql-general by date:

Previous
From: "Thom Brown"
Date:
Subject: Advantage of more than 1 tablespace on 1 disk?
Next
From: Rainer Pruy
Date:
Subject: Re: Advantage of more than 1 tablespace on 1 disk?