Geoff Parker <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
