Growing Database Size
От | Jason Godden |
---|---|
Тема | Growing Database Size |
Дата | |
Msg-id | 200306141635.16742.jasongodden@optushome.com.au обсуждение исходный текст |
Ответы |
Re: Growing Database Size
|
Список | 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
В списке pgsql-general по дате отправления: