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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/src/backend/commands cluster.c
Date: 2002-11-04 02:42:43
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> If the pg_statistic entries were already good, then you shouldn't need
>> an ANALYZE, no.

> The CLUSTER manual page recommends a analyze to update the clustered
> nature of the table. Is that still needed?

Oh, you're right, I was not thinking about the order-correlation
statistic. Yes, ANALYZE is still needed if you want to update that
stat, which you probably do. The swap hack just ensured that relpages
amd reltuples would be correct after a CLUSTER.

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Barry Lind 2002-11-04 06:42:33 pgsql-server/src/interfaces/jdbc/org/postgresq ...
Previous Message Bruce Momjian 2002-11-04 02:34:51 Re: pgsql-server/src/backend/commands cluster.c