> Agreed. I am starting a list of what can/need to be indexed on pgsql docs
> site as I'm working to build a new site with pgsql as a backend. I
> think Tom Lane > suggested that.. I would like to know where I can send
> the list. It'll probably somekind of a work in progress. So if everyone
> else can contribute, > it'll be so much faster. Probably a semi-automated
> system for handling those
> lists?
Assuming some kind of full-text search facility, an interesting idea would
be a self-updating index, one that keeps track of what search terms
are commonly used and adds those to the index automatically.
--
Mike Nolan
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
