On Wed, Nov 26, 2008 at 10:21 AM, Rafael Domiciano <[EMAIL PROTECTED]> wrote: > I'm not using autovacuum. Regular vacuum goes ok. > To see the last 10 lines of verbose i will need to run vacuum tonight > If a run a reindex before the vacuum full, increase the "speed" of doing > vacuum? I found something about it googling.
You should look into enabling autovac. You can set the sleep parameter to 10 or 20 to keep it from hogging your I/O bandwidth. Also, reindex AFTER the vacuum full, not before. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
