Questions On Tablespace

From: Carlo Camerino <carlo(dot)camerino(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions On Tablespace
Date: 2009-09-27 18:27:59
Message-ID: 3fee29160909271127y3b430e59x8bc31408d85b888c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Everyone,

I have questions regarding tablespaces, What happens when the disk on
which my tablespace is in fills up?
How do I expand my tablespace, in oracle there is a concept of
datafiles? In postgresql I specify a directory instead of a single
file...

For example I have two tables and they both use a single tablespace.
After some time the tablespace fills up. How do I point one table to
use a new tablespace?
Or is there a way in which I can get my tablespace to increase size by
using another disk for this purpose?
What's the best approach to this situation?

Thanks A Lot
Carlo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-09-27 18:34:29 Re: CREATE LANGUAGE workaround
Previous Message InterRob 2009-09-27 18:26:27 Re: generic modelling of data models; enforcing constraints dynamically...