"Chris White (cjwhite)" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org