Re: [GENERAL] limited disk space

2005-03-30 Thread Peter Eisentraut
David Parker wrote: > Is anybody running postgres in a similar constrained environment, or > are there any general tips on controlling disk usage that somebody > could point me to? PostgreSQL is not particularly tuned to such scenarios. The only chance you have to control disk usage is to vacuum

[GENERAL] limited disk space

2005-03-30 Thread David Parker
We need to run a server (7.4.5, Solaris 9/Intel) in an environment with a defined limit on disk size. We know basically the set of data we will be working with, and can size the disk space accordingly, but there will be a fair amount of update churn in the data.   We are running autovacuum,