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)
Список
Дерево обсуждения
Autovaccum and Full vacuum Tony Day <tonyd@panztel.com>
Re: Autovaccum and Full vacuum Shoaib Mir <shoaibmir@gmail.com>
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 по дате отправления
