On Tue, Aug 23, 2005 at 01:19:11PM +0200, A. Kretschmer wrote: > am 23.08.2005, um 15:12:54 +0530 mailte Vishnu folgendes: > > How can I limit the maximum space uses by Posgres database ??. So that it > > should not use total disk space available on system. > > You can use the tools from the os, under Linux for instance quotas. Be aware that exceeding a disk quota might cause problems beyond a simple "Sorry, you can't insert any more records" error. http://www.postgresql.org/docs/8.0/static/disk-full.html Even with a quota in place, you should probably monitor the database's disk usage so you can take action before the quota is exceeded. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
