Craig,
could you prepare excerption from your db (if possible), so I could
play myself ?
Oleg
On Mon, 17 Oct 2005, Craig A. James wrote:
Oleg wrote:
Did you consider *decreasing* SIGLENINT ? Size of index will diminish
and performance could be increased. I use in current project SIGLE
Oleg wrote:
Did you consider *decreasing* SIGLENINT ? Size of index will diminish
and performance could be increased. I use in current project SIGLENINT=15
The default value for SIGLENINT actually didn't work at all. It was only by
increasing it that I got any performance at all. An examinat
On Sat, 15 Oct 2005, Craig A. James wrote:
We are indexing about 5 million small documents using tsearch2/GIST. Each
"document" contains 2 to 50 words. This is a "write once, read many"
situation. Write performance is unimportant, and the database contents are
static. (We build it offline.
We are indexing about 5 million small documents using tsearch2/GIST. Each "document"
contains 2 to 50 words. This is a "write once, read many" situation. Write performance
is unimportant, and the database contents are static. (We build it offline.)
We're having problems with inconsistent pe
We are indexing about 5 million small documents using tsearch2/GIST. Each "document"
contains 2 to 50 words. This is a "write once, read many" situation. Write performance
is unimportant, and the database contents are static. (We build it offline.)
We're having problems with inconsistent pe