Re: [HACKERS] Autovacuum loose ends

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Autovacuum loose ends
Date: 2005-08-01 07:55:11
Message-ID: 0bea01c5966e$58cd5db0$d501a8c0@zaphod
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Alvaro Herrera wrote:

> Here is another patch for autovacuum:
...
> - Xid-wraparound VACUUM is now FULL without ANALYZE

Am I right in my assumption that this VACUUM FULL can happen for any
database, not just a template database?

I think this is a bad idea. Vacuum full is not an option for our and many
other production databases. I suggest that should be a plain VACUUM.

Otherwise I think you have done great job finally integrating auto vacuum
into the backend.

Best Regards,
Michael Paesold

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2005-08-01 08:17:21 Re: Remote administration functionality
Previous Message Dave Page 2005-08-01 07:41:19 Re: Remote administration functionality

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Page 2005-08-01 08:46:26 Re: [HACKERS] For review: Server instrumentation patch
Previous Message Bruce Momjian 2005-08-01 02:26:27 Re: [HACKERS] For review: Server instrumentation patch