Hi,
we currently want to employ PG and Gin Index for light-weight full text search engine. however,
we encounter a problem that Gin Index is not quick enough for relevence, because it must
scan all heaptuples which statisfy the condition, then invoke ts_rank to compute the rank of tuple.
an idea comes to us: add some foundamental ranking features to the Gin index structure;
then we can find the most relevance tuples just from index, which result in a problem that we must
add a type of indexscan and heapscan,customize plan. but PG don't support the behaviors,.
As far as I know, oracle support customizing plan. My question is how can i slove it, and whether PG
will support extending indexscan and heapscan,customizing plan in future.
Thanks
--zhuxiang
Yahoo! CN
