Re: ANALYZE after restore - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ANALYZE after restore
Date
Msg-id 10511.1017856566@sss.pgh.pa.us
Whole thread Raw
In response to Re: ANALYZE after restore  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-hackers
Jan Wieck <janwieck@yahoo.com> writes:
>     ... And  PostgreSQL  needs  some  frequent  VACUUM
>     anyway, so after a while this problem solves itself  for  the
>     average user.

Yes, that's the key point for me too.  Anyone who doesn't set up for
routine vacuums/analyzes is going to have performance problems anyway.
Attacking that by making pg_dump force a vacuum is attacking the wrong
place.

There's been discussion of adding automatic background vacuums to
Postgres; that seems like a more useful response to the issue.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Locale support is now on by default
Next
From: Hervé Piedvache
Date:
Subject: PSQL completion !? v7.2.1