s being updated, and that table later ended up with a bunch of
empty pages at the end of the table, which vacuum then removed.
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
To: Geoff Parker <[EMAIL PROTECTED]>
Cc: pgsql admin
Sent: Tuesday, August 8, 2006 12:12:44 PM
min Sent: Tuesday, August 8, 2006 12:12:44 PMSubject: Re: [ADMIN] disk usage spike 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
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
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 (agai
