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
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,