Re: disk usage spike

Geoff Parker <geoffparkernews@yahoo.ca> writes:
> I have a database with about 155GB of binary data in large objects and 15GB of data in other tables.  In compressed
form,it consumes about 60GB on disk.  On friday, the amount of disk usage increased to 240GB (over a period of 5
minutes),stayed at 240GB for 2 days, and then returned to 60GB (again over a period of about 5 minutes). 

It's impossible to say much with only that amount of information.  If we
knew what part of the database had bloated (table? index? WAL log?) we
could perhaps offer some wisdom.  Next time, use "du" and and related
tools to see where the space went.

            regards, tom lane