"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