Re: pgsql-server/src/backend/commands cluster.c - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql-server/src/backend/commands cluster.c
Date
Msg-id 25280.1036375176@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql-server/src/backend/commands cluster.c  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: pgsql-server/src/backend/commands cluster.c  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-committers
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> On Sat, Nov 02, 2002 at 04:20:47PM -0500, Tom Lane wrote:
>> During swap_relfilenodes, swap relation size statistic fields along with
>> the relfilenode and toast fields.  This ensures that the newly-computed
>> statistics will be available on completion of CLUSTER.

> I haven't seen the change, but does this mean that ANALYZE is no longer
> needed right after CLUSTER?

If the pg_statistic entries were already good, then you shouldn't need
an ANALYZE, no.

            regards, tom lane

pgsql-committers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pgsql-server/src/bin/psql print.c
Next
From: Tom Lane
Date:
Subject: Re: pgsql-server/src/bin/psql print.c