Growing Database Size

From: Jason Godden <jasongodden(at)optushome(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Growing Database Size
Date: 2003-06-14 06:35:16
Message-ID: 200306141635.16742.jasongodden@optushome.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Godden 2003-06-14 08:57:42 Growing Database Size Solved
Previous Message Tom Lane 2003-06-14 04:06:22 Re: [HACKERS] SAP and MySQL ... [and Benchmark]