| 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> |
| Subject: | Re: disk usage spike |
| Date: | 2006-08-08 02:12:44 |
| Message-ID: | 24609.1155003164@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoff Parker | 2006-08-08 03:36:12 | Re: disk usage spike |
| Previous Message | Benjamin Krajmalnik | 2006-08-08 02:08:23 | Strange UTF8 issue with pg_dump/pg_restore |