Postgres, tablespaces, and quotas

John Browne <jkbrowne@gmail.com> writes:

I was just curious about what would happen given the following scenario:

- Unix user has their own tablespace (and corresponding database)
stored in /home/someuser/mydata
- Quotas are enabled on /home
- User reaches their quota, effectively causing only this tablespace
to run out of disk space.

How would postgres handle this scenario?

It's not tested very often but I think it should work all right ---
insertions and updates into that tablespace might fail but otherwise
no problem.

What you want to watch out for is running out of space for pg_xlog
or pg_clog. Either one will cause a database panic shutdown. No
data loss, but no service either till you free up some space :-(

regards, tom lane