Re: disk usage spike

Unfortunately I didn't notice the problem until I saw the logs today, and by then it was back tor normal.

Is it safe to assume this is abnormal behaviour?

Geoff.

----- Original Message ----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Geoff Parker <geoffparkernews(at)yahoo(dot)ca>
Cc: pgsql admin <pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, August 8, 2006 12:12:44 PM
Subject: Re: [ADMIN] disk usage spike

Geoff Parker <geoffparkernews(at)yahoo(dot)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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend