Re: [ADMIN] disk usage spike

2006-08-07 Thread Geoff Parker
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 <[EMAIL PROTECTED]>To: Geoff Parker <[EMAIL PROTECTED]>Cc: pgsql ad

[ADMIN] disk usage spike

2006-08-07 Thread Geoff Parker
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

[ADMIN] Disk usage in postgresql 8.1.4

2006-08-06 Thread Geoff Parker
Hi, I've got a database with about 155GB of binary data, however when I run the unix utility df, it reports only 60GB of disk space is being used.   I've extracted random samples of data from the database, and it all appears correct, so I presume it's not corrupt.   Can anyone tell me whether there