Re: analyze after a database restore?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, mlw <pgsql(at)mohawksoft(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: analyze after a database restore?
Date: 2003-03-18 14:34:53
Message-ID: Pine.LNX.4.44.0303180145180.1975-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian writes:

> Attached is a committed patch to add a recommendation for ANALYZE after
> restore. It is a shame we only have vacuumdb -a to do analyze _and_
> vacuum, and no analyze-only option.

Isn't one copy of the text per reference page enough?

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-03-18 14:35:38 Re: [INTERFACES] Upgrading the backend's error-message infrastructure
Previous Message Bruce Momjian 2003-03-18 14:30:51 Red Hat snubbed by Oracle