Обсуждение: Questions On Tablespace

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

Carlo Camerino <carlo.camerino@gmail.com> writes:
> I have questions regarding tablespaces, What happens when the disk on
> which my tablespace is in fills up?

You start getting errors.

> 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...

If you expect to need to expand the filesystem, you should be using
LVM or local equivalent so that you can add or remove disks from
the filesystem as needed.

Oracle's design dates from a time when filesystems tended to suck and so
Oracle felt it should reimplement all the filesystem-level functionality
for itself.  Postgres is not interested in reinventing the wheel, so we
don't do that.  You won't find any "raw disk access" functions in
Postgres either.

            regards, tom lane