Re: Question about DB VACUUM

Tom,

You were right, 1 or 2 of the large objects weren't actually getting
removed from the table, each cycle. I wasn't running on a completely
empty database when I first started, so I didn't notice the undeleted
objects.

The program which interfaces to the database uses the JDBC method
LargeObject.delete() to delete the large object associated to the entry
in the users data table. Plus every night I have a program which goes
through the database and checks for and removes large objects which are
no longer being referenced by any table.

I am now trying to find out why the occasion entry doesn't get deleted.

Chris

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, October 02, 2003 3:46 PM
To: cjwhite(at)cisco(dot)com
Cc: 'Robert Treat'; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Question about DB VACUUM

"Chris White (cjwhite)" <cjwhite(at)cisco(dot)com> writes:
> The index has grown by 4 pages and the table has grown by 10 pages.
> BTW, what is a page size? Why is this happening as this is the table
> that I am theoretically keeping the same size by adding/deleting the
> same objects from.

Kinda looks like you aren't doing anything to remove
no-longer-referenced large objects. An LO is not a BLOB; it has an
independent existence. You may care to look into contrib/lo and/or
contrib/vacuumlo. Or possibly you should be using wide text or bytea
fields, not large objects at all...

regards, tom lane