Advantage of more than 1 tablespace on 1 disk?

From: "Thom Brown" <thombrown(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Advantage of more than 1 tablespace on 1 disk?
Date: 2008-11-03 10:36:13
Message-ID: bddc86150811030236o169542eck8e476d2a561612d3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've got a database with massive tables which fall into 2 categories:
Tables which don't change often but get read a LOT, and tables which
are heavily added to continuously and sometimes read.

Would there be any advantage in moving the latter logging tables to a
separate tablespace, bearing in mind it would still be on the same
disk? Or have I kinda missed how tablespaces work?

Thanks

Thom

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-11-03 11:14:46 Re: Advantage of more than 1 tablespace on 1 disk?
Previous Message Peter Eisentraut 2008-11-03 09:50:12 Re: Are there plans to add data compression feature to postgresql?