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
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] |