pgsql: Fix ANALYZE's ancient deficiency of not trying to collect stats - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix ANALYZE's ancient deficiency of not trying to collect stats
Date
Msg-id 20100801223820.1E5597541D5@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Fix ANALYZE's ancient deficiency of not trying to collect stats for expression
indexes when the index column type (the opclass opckeytype) is different from
the expression's datatype.  When coded, this limitation wasn't worth worrying
about because we had no intelligence to speak of in stats collection for the
datatypes used by such opclasses.  However, now that there's non-toy
estimation capability for tsvector queries, it amounts to a bug that ANALYZE
fails to do this.

The fix changes struct VacAttrStats, and therefore constitutes an API break
for custom typanalyze functions.  Therefore we can't back-patch it into
released branches, but it was agreed that 9.0 isn't yet frozen hard enough
to make such a change unacceptable.  Ergo, back-patch to 9.0 but no further.
The API break had better be mentioned in 9.0 release notes.

Tags:
----
REL9_0_STABLE

Modified Files:
--------------
    pgsql/src/backend/commands:
        analyze.c (r1.152 -> r1.152.4.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/analyze.c?r1=1.152&r2=1.152.4.1)
    pgsql/src/include/commands:
        vacuum.h (r1.89 -> r1.89.6.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/vacuum.h?r1=1.89&r2=1.89.6.1)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix ANALYZE's ancient deficiency of not trying to collect stats
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Back-patch fix for renaming asyncCommitLSN to asyncXactLSN.