Skip site navigation (1) Skip section navigation (2)

pgsql: Create a type-specific typanalyze routine for tsvector, which

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create a type-specific typanalyze routine for tsvector, which
Date: 2008-07-14 00:51:46
Message-ID: 20080714005146.29D28754A84@cvs.postgresql.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Create a type-specific typanalyze routine for tsvector, which collects stats
on the most common individual lexemes in place of the mostly-useless default
behavior of counting duplicate tsvectors.  Future work: create selectivity
estimation functions that actually do something with these stats.

(Some other things we ought to look at doing: using the Lossy Counting
algorithm in compute_minimal_stats, and using the element-counting idea for
stats on regular arrays.)

Jan Urbanski

Modified Files:
--------------
    pgsql/doc/src/sgml:
        catalogs.sgml (r2.167 -> r2.168)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml?r1=2.167&r2=2.168)
    pgsql/src/backend/catalog:
        system_views.sql (r1.52 -> r1.53)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql?r1=1.52&r2=1.53)
    pgsql/src/backend/tsearch:
        Makefile (r1.6 -> r1.7)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/Makefile?r1=1.6&r2=1.7)
    pgsql/src/include/catalog:
        catversion.h (r1.466 -> r1.467)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.466&r2=1.467)
        pg_operator.h (r1.160 -> r1.161)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_operator.h?r1=1.160&r2=1.161)
        pg_proc.h (r1.504 -> r1.505)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h?r1=1.504&r2=1.505)
        pg_statistic.h (r1.35 -> r1.36)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_statistic.h?r1=1.35&r2=1.36)
        pg_type.h (r1.196 -> r1.197)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_type.h?r1=1.196&r2=1.197)
    pgsql/src/include/tsearch:
        ts_type.h (r1.12 -> r1.13)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_type.h?r1=1.12&r2=1.13)
    pgsql/src/test/regress/expected:
        rules.out (r1.139 -> r1.140)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out?r1=1.139&r2=1.140)

Added Files:
-----------
    pgsql/src/backend/tsearch:
        ts_typanalyze.c (r1.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/ts_typanalyze.c?rev=1.1&content-type=text/x-cvsweb-markup)

pgsql-committers by date

Next:From: Tom LaneDate: 2008-07-14 03:22:33
Subject: pgsql: Clean up buildfarm failures arising from the seemingly
Previous:From: User FxjrDate: 2008-07-13 23:21:16
Subject: npgsql - Npgsql2: [#1010425] Patch for actual german translation Added

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group