Re: How to cope with low disk space

	Michiel Holtkamp wrote:

> Running low on disk space can also happen when something goes wrong 
with
> the recording trigger (this can be a hardware fault). In both cases, 
we
> don't want to store even more data, but we will want to make a 
selection
> based on age (newer data is more important). 

Did you think about testing pg_relation_size('pg_largeobject') against 
a fixed threshold before allocating new large objects?
If it's higher than the threshold, you could either stop importing new 
data, or lo_unlink-ing older entries and immediately issuing a plain 
vacuum before continuing.

-- 
 Daniel
 PostgreSQL-powered mail user agent and storage: 
http://www.manitou-mail.org