Hi All,
I've got a bit of a dilemma with growing database sizes. Before upgrading to
7.3.2 my 7.3.0 database had an average size of 1.4-2.0gb. I have a large
number of LO records in my db and presumed the size growth was because of
them. However I do have the appropriate trigger functions on my LO records
to ensure that lo_manage runs to unlink the old reference etc.
Since moving to 7.3.2, even though I VACUUM regularly, my DB size has
increased to 3.2GB on disk!! The raw data only consumes about 700-900mb so I
feel that an additional 2.2gb for index and statistics info is a bit much!
Any clues from the experienced among the group?
PS - strange thing is that even with that huge change on disk PG's performance
hasn't really been affected... weird.
Thanks,
Jason