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 and checkpoint a lot. There is no general "use only X bytes" control, nor a combination of controls that amount to such. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match