Re: Questions On Tablespace

Carlo Camerino <carlo(dot)camerino(at)gmail(dot)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