Carlo Camerino <carlo.camerino@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
