John Browne <jkbrowne@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
