Re: [PATCHES] Multi-column GIN

2008-07-04 Thread Oleg Bartunov
39 Mb538 Mb Speed: *1.885* ms4.994 ms Index: ~340 s~200 s Insert: 72 s/166 s/1 Well, another reason is a index feature-completeness Regards, Oleg _ Oleg Bartunov, Research Scie

Re: [PATCHES] Partial match in GIN (next vesrion)

2008-05-16 Thread Oleg Bartunov
t be checkable by the index. The advantage is that the index bloat factor is governed by the average word length not the average whole-string length. There are probably other approaches that would help, too. regards, tom lane Regards, Oleg ___

Re: [PATCHES] Indexam API changes

2008-04-07 Thread Oleg Bartunov
or in 8.4 ! If people think it's worth it, I can fix the bit-rot in the patch and work on it, but personally I don't think it is. Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (

Re: [PATCHES] [HACKERS] Include Lists for Text Search

2008-03-09 Thread Oleg Bartunov
ttle middleware would help implement this, and CaseSensitive too. Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Inter

Re: [PATCHES] a tsearch2 (8.2.4) dictionary that only filters out stopwords

2007-11-14 Thread Oleg Bartunov
On Wed, 14 Nov 2007, Tom Lane wrote: Oleg Bartunov <[EMAIL PROTECTED]> writes: On Wed, 14 Nov 2007, Tom Lane wrote: Huh? This is just an option for the "simple" dictionary, it's got nothing to do with thesaurus AFAICS. I can assign simple dictionary as a normali

Re: [PATCHES] a tsearch2 (8.2.4) dictionary that only filters out stopwords

2007-11-14 Thread Oleg Bartunov
On Wed, 14 Nov 2007, Tom Lane wrote: Oleg Bartunov <[EMAIL PROTECTED]> writes: On Wed, 14 Nov 2007, Tom Lane wrote: One thought that came to mind is that the option name should be just "Accept" not "AcceptAll". To me "All" implies that it would accept

Re: [PATCHES] a tsearch2 (8.2.4) dictionary that only filters out stopwords

2007-11-14 Thread Oleg Bartunov
On Wed, 14 Nov 2007, Tom Lane wrote: Oleg Bartunov <[EMAIL PROTECTED]> writes: Let's consider one example - removing accents. In the past I always recommend people to use regex functions before to_tsvector conversion to remove accents, but recently I was noticed that such trick d

Re: [PATCHES] a tsearch2 (8.2.4) dictionary that only filters out stopwords

2007-11-14 Thread Oleg Bartunov
consider adding a new feature so late in the development cycle, but this seems small enough and useful enough to make an exception. Comments? regards, tom lane Regards, Oleg _____ Oleg B

Re: [PATCHES] Preliminary patch for tsearch example dictionaries/parsers in contrib

2007-10-09 Thread Oleg Bartunov
Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495

Re: [PATCHES] Bunch of tsearch fixes and cleanup

2007-08-23 Thread Oleg Bartunov
recoding and please, don't lowercase. Dictionaries are very different. regards, tom lane Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Ste

Re: [PATCHES] First implementation of GIN for pg_trgm

2007-02-22 Thread Oleg Bartunov
x27;t investigate the possibility to keep additional information with index, but keep in mind, that everything should works without index. Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.as

Re: [PATCHES] [pgsql-ru-general] [HACKERS] Final call for translation updates

2005-01-04 Thread Oleg Bartunov
Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of

Re: [PATCHES] contrib/ sparse code cleanup

2004-11-05 Thread Oleg Bartunov
-Neil Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone