Re: Autovaccum and Full vacuum
| От | Shoaib Mir |
|---|---|
| Тема | Re: Autovaccum and Full vacuum |
| Дата | |
| Msg-id | x2jbf54be871005042201g3865b946jb2df7180a12f249c@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Autovaccum and Full vacuum (Tony Day <tonyd@panztel.com>) |
| Ответы |
Re: Autovaccum and Full vacuum
|
| Список | pgsql-novice |
On Wed, May 5, 2010 at 2:46 PM, Tony Day <tonyd@panztel.com> wrote:
--
Shoaib Mir
http://shoaibmir.wordpress.com/
Hi Shoaib
Thanks for the response.
Sorry - I forgot to mention that I am using PostgreSQL 8.3.9 on Ubuntu 9.04.
And just to be clear - I am not suggesting that there is a bug in Postgresql :-)
I am just trying to clarify what it does and doesn't do.
You can find on docs autovacuum at http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html#AUTOVACUUM
It uses VACUUM and not VACUUM FULL, there shouldn't be a need of VACUUM FULL if you have autovacuum enabled with proper thresholds. There can be an odd case where you might have to make auto-vacuum a little more aggressive for a specific table.
Shoaib Mir
http://shoaibmir.wordpress.com/
В списке pgsql-novice по дате отправления: