Impact of vacuum full...
От | Erik Jones |
---|---|
Тема | Impact of vacuum full... |
Дата | |
Msg-id | 44C0EF1C.9070706@myemma.com обсуждение исходный текст |
Ответы |
Re: Impact of vacuum full...
Re: Impact of vacuum full... |
Список | pgsql-general |
Hello, I was wondering if someone could enlighten me as to the impact to the entire database of running VACUUM FULL against a single table. The reason I ask is that at company we work for we have a very large number of queue type tables that fill up and empty out on a regular basis, on the average every two days per table would be a good estimate. These tables, when filled, can contain anywhere from less than 50 to upwards of 500,000 entries. We recently moved out db over to a new box as the old one wasn't cutting it (we haven't been able to run a successful VACUUM FULL on the whole db in over a year and after the transfer our db was smaller by 50GB!!!). Thus we are looking into a more aggressive vacuuming strategy for these table in order to keep our database lean and clean for the purpose of quick and fast dumps and general performance issues otherwise. Also, what kind of times am I looking at to do VACUUM FULL's on single tables of different sizes? Thank you for any advice/input you may have... -- erik jones <erik@myemma.com> software development emma(r)
В списке pgsql-general по дате отправления: