Re: [PERFORM] tsearch2/GIST performance factors?

2005-10-17 Thread Oleg Bartunov
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

Re: [PERFORM] tsearch2/GIST performance factors?

2005-10-17 Thread Craig A. James
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

Re: [PERFORM] tsearch2/GIST performance factors?

2005-10-17 Thread Oleg Bartunov
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.

[PERFORM] tsearch2/GIST performance factors?

2005-10-17 Thread Craig A. James
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

[PERFORM] tsearch2/GIST performance factors?

2005-10-17 Thread Craig A. James
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