Re: [GENERAL] Incorrect FTS result with GIN index

2010-07-20 Thread Oleg Bartunov
: 5835.83 clflush size: 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual power management: Oleg Bartunov wrote: Artur, I don't know, but could you try linux machine ? Oleg Regards, Oleg

Re: [GENERAL] Full Text Search ideas

2010-07-20 Thread Oleg Bartunov
thoughts on the subject! Regards HJR Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su

Re: [GENERAL] Incorrect FTS result with GIN index

2010-07-19 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via

Re: [GENERAL] Incorrect FTS result with GIN index

2010-07-17 Thread Oleg Bartunov
uGLeLccAeSuLWIn Ii nS (14 rows) Did I misunderstood something or is it a bug? Best regards Artur Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical

Re: [GENERAL] tsearch2 dictionaries - possible problem

2010-06-03 Thread Oleg Bartunov
). Is there something wrong in the configuration? I would definitely not want unknown words to be ignored. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical

[GENERAL] PGCon 2010 pictures available

2010-05-30 Thread Oleg Bartunov
missing comments. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera

Re: [GENERAL] Full Text Search : Parse date

2010-05-11 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495

Re: [GENERAL] fulltext search stemming/ spelling problems

2010-04-08 Thread Oleg Bartunov
or ts_dict() for testing. Thanks, Corin Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o

Re: [GENERAL] fulltext search stemming/ spelling problems

2010-04-08 Thread Oleg Bartunov
On Thu, 8 Apr 2010, Corin wrote: On 08.04.2010 20:15, Oleg Bartunov wrote: On Thu, 8 Apr 2010, Corin wrote: english_ispell dictionary is a morphology kind of dictionary ! Read docs. Also, simple dictionary will never invoked, since english_stem dictionary recognizes everything ! I'm not sure

Re: [GENERAL] Full Text Search: howto manage multiple languages ?

2010-03-22 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general

Re: [GENERAL] like operation in tsearch

2010-03-21 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] turning a tsvector without position in a weighted tsvector

2010-02-08 Thread Oleg Bartunov
positions? Is there any use-case? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [GENERAL] Problem with pg_compresslog'd archives

2010-02-07 Thread Oleg Bartunov
. -- Karl Denninger Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [GENERAL] FTS uses tsquery directly in the query

2010-01-25 Thread Oleg Bartunov
? If so, how? Thank! Xu --- On Sun, 1/24/10, Oleg Bartunov You're trying to solve a similar problems than mine. I'd like to build up a n=C3=A4ive similar text search. I don't have the length problem still I'd like to avoid to tokenize/lexize a text twice to build up a tsquery. I've weighted tsvectors

Re: [GENERAL] FTS uses tsquery directly in the query

2010-01-23 Thread Oleg Bartunov
Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939

Re: [GENERAL] ranking how similar are tsvectors was: OR tsquery

2010-01-17 Thread Oleg Bartunov
documents to find similar ones. An operator that check the intersection of tsvectors would come handy. Adding a ts_rank(tsvector, tsvector) will surely help too. thanks Regards, Oleg _ Oleg Bartunov, Research

Re: [GENERAL] OR tsquery

2010-01-16 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing list

Re: [GENERAL] What is the simpliest text search configuration?

2009-11-12 Thread Oleg Bartunov
the stopwords filtering. I tried pg_catalog.simple, but despite its name, it still considers stop words. Thanks for your help! Jerome. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

[GENERAL] contrib/plantuner - enable PostgreSQL planner hints

2009-10-06 Thread Oleg Bartunov
..140.00 rows=12 width=4) Filter: (id = 1) (2 rows) Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o

Re: [GENERAL] generic modelling of data models; enforcing constraints dynamically...

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

Re: [GENERAL] generic modelling of data models; enforcing constraints dynamically...

2009-09-28 Thread Oleg Bartunov
a lot, Oleg! Tips tricks to get this going in PostgreSQL? Rob 2009/9/28 Oleg Bartunov o...@sai.msu.su Have you considered contrib/hstore to build flexible database scheme ? Oleg On Sun, 27 Sep 2009, InterRob wrote: Dear David, dear Peter, dear all, Peter, I was happy reading your reply right

Re: [GENERAL] tsvector Column Indexing Across Two Tables

2009-09-07 Thread Oleg Bartunov
read further documentation you'll discover it's wise to assign different weights for subject and body for better ranking. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru

Re: [GENERAL] Full-Text Searching: to_tsquery() vs. plainto_tsquery()

2009-09-04 Thread Oleg Bartunov
to formatting issues. How does everyone implement the typical boolean full-text search in their database? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical

Re: [GENERAL] Improving Full text performance

2009-08-23 Thread Oleg Bartunov
. Thanks! Ps: I cannot use other tools like MNOsearch, lucene, etc...because i have no root pass to my server. On 22 ago, 02:20, o...@sai.msu.su (Oleg Bartunov) wrote: On Fri, 21 Aug 2009, xaviergxf wrote: Hi, =A0 I?m using php and full text on postgresql 8.3 for indexing html descriptions

Re: [GENERAL] Improving Full text performance

2009-08-21 Thread Oleg Bartunov
want. Read documentation for details. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su

Re: [GENERAL] Add Space symbols for TSvector

2009-06-25 Thread Oleg Bartunov
for IPnumbers in test like world/123.456.192.46(0) - some-fwsm/123.456.221.121(0) preprocess text, for example, using replace(), regexp_replace() functions Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

Re: [GENERAL] GiST or GIN, I feel like I am doing something wrong

2009-06-17 Thread Oleg Bartunov
. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16

Re: [GENERAL] Text search without dictionary ?

2009-06-09 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] problem with FOUND and EXECUTE in pl/pgsql

2009-06-03 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing

Re: [GENERAL] problem with FOUND and EXECUTE in pl/pgsql

2009-06-03 Thread Oleg Bartunov
On Wed, 3 Jun 2009, Tom Lane wrote: Oleg Bartunov o...@sai.msu.su writes: seems I don't understand how FOUND variable in pl/pgsql function defined, when I use EXECUTE of PERFORM. There is no problem when I use plain SQL. EXECUTE doesn't affect FOUND, even if the statement-to-be-executed

Re: [GENERAL] tsearch2 dictionary for statute cites

2009-04-07 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing list

Re: [GENERAL] tsearch2 dictionary for statute cites

2009-04-07 Thread Oleg Bartunov
On Tue, 7 Apr 2009, Kevin Grittner wrote: Oleg Bartunov o...@sai.msu.su wrote: of course, you can build tsquery youself, but once your parser can recognize your very own token 'xxx', it'd be much better to have mapping xxx - dict_xxx, where dict_xxx knows all semantics. I probably just need

Re: [GENERAL] tsearch2 dictionary for statute cites

2009-04-07 Thread Oleg Bartunov
://vo.astronet.ru/arxiv/dict_regex.html Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [GENERAL] partial TEXT search on an index

2009-03-31 Thread Oleg Bartunov
); does not use the index. What Do i need to do to have it recognise the partial index? (is it called?) No, that's not a partial index (look at e.g. wiki for an explanation). Ciao, Thomas Regards, Oleg _ Oleg

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-21 Thread Oleg Bartunov
for each lexem. I think It would be better to specify searched vectors per-query. we provide low level interface, it's up to you to write your very own query processing. Oleg Bartunov wrote: On Fri, 20 Mar 2009, esemba wrote: Well, thank you both for response, but I'm not sure, I understand

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-20 Thread Oleg Bartunov
choose which columns to search. Thank you for your reply. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-20 Thread Oleg Bartunov
to search only annotation, sometimes resume, sometomes both. if you assign different labels to the concatenated columns, you can specify in query which columns you're interested in. Also, you can explicitly specify weight=0 for columns you're not interested. Oleg Bartunov wrote: On Thu, 19

Re: [GENERAL] Accent insensitive search?

2009-03-18 Thread Oleg Bartunov
to the 8.5 release Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su

Re: [GENERAL] tsearch2 dictionary for statute cites

2009-03-11 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83

Re: [GENERAL] postgreSQL amazon ec2 cloud

2009-03-03 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general

Re: [GENERAL] Accessing array elements in a FOR PL/pgsql loop

2009-02-19 Thread Oleg Bartunov
1 2 3 (3 rows) Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [GENERAL] select max from subquery

2009-02-14 Thread Oleg Bartunov
(foo.qq) from (select 1 as qq) as foo; ^^ ^^ thanks Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow

Re: [GENERAL] TSearch queries with multiple languages

2009-02-12 Thread Oleg Bartunov
, will allow to create composite index like (ts_config, tsvector), so queries which specified ts_config (language) will uses this index. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

Re: [GENERAL] How to use compoundwords controlled z when creating dictionary

2009-02-06 Thread Oleg Bartunov
on splitting compound words. Adding the line compoundwords controlles z to the affix file returns an error ERROR: wrong affix file format for flag Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

Re: [GENERAL] Searching a gin index

2009-02-06 Thread Oleg Bartunov
it easier to debug problems. -- Richard Huxton Archonet Ltd Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia

Re: [GENERAL] Searching a gin index

2009-02-06 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via

Re: [GENERAL] Turning off automatic ranking on words

2009-02-06 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing

Re: [GENERAL] Searching a gin index

2009-02-06 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939

Re: [GENERAL] Full text index not being used

2009-02-03 Thread Oleg Bartunov
that doesn't mean I need to rebuild this column over the course of 3 days - I didn't expect it to take this long so I thought I'd just try it out. On Feb 2, 2009, at 1:49 AM, Oleg Bartunov wrote: Alex, what text you're indexing ? I don't believe you have meaningful very long words ( 2047

Re: [GENERAL] dict-xsyn converts word to synlist, what about backwards?

2009-02-03 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83

Re: [GENERAL] dict-xsyn converts word to synlist, what about backwards?

2009-02-03 Thread Oleg Bartunov
I contacted with author of dict_xsyn, so probably, he'll add option to support what you want. Oleg On Tue, 3 Feb 2009, Igor Katson wrote: Oleg Bartunov wrote: On Tue, 3 Feb 2009, Igor Katson wrote: On my question about doing a first name search by it's synonyms, like William Will Bill

Re: [GENERAL] Text search, ERROR: invalid byte sequence for encoding UTF8: 0xe9640a

2009-02-03 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql

Re: [GENERAL] Full text index not being used

2009-02-03 Thread Oleg Bartunov
) AND (post_time = '2009-02-05 08:14:58.262034'::timestamp without time zone))Total runtime: 1368.722 ms On Feb 3, 2009, at 8:15 PM, Oleg Bartunov wrote: Alex, can you somehow identify document, which has problem with long word errors ? Also, if you have space on disk I'd recommend to try

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Oleg Bartunov
me this error : (again the affix file) ERROR: wrong affix file format for flag CONTEXT: line 560 of configuration file C:/Program Files/PostgreSQL/8.3/share/tsearch_data/arabic_utf8_alias.affix: PFX 1013 Y 6 / Moe On Mon, Feb 2, 2009 at 2:41 PM, Oleg Bartunov o...@sai.msu.su wrote: Mohamed

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Oleg Bartunov
2, 2009 at 3:50 PM, Oleg Bartunov o...@sai.msu.su wrote: Mohamed, comment line in ar.affix #FLAG long and creation of ispell dictionary will work. This is temp, solution. Teodor is working on fixing affix autorecognizing. I can't say anything about testing, since somebody should provide first

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Oleg Bartunov
On Mon, 2 Feb 2009, Oleg Bartunov wrote: On Mon, 2 Feb 2009, Mohamed wrote: Hehe, ok.. I don't know either but I took some lines from Al-Jazeera : http://aljazeera.net/portal just made the change you said and created it successfully and tried this : select ts_lexize('ayaspell

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Oleg Bartunov
Mohamed, please, try to read docs and think a bit first. On Mon, 2 Feb 2009, Mohamed wrote: On Mon, Feb 2, 2009 at 4:34 PM, Oleg Bartunov o...@sai.msu.su wrote: On Mon, 2 Feb 2009, Oleg Bartunov wrote: On Mon, 2 Feb 2009, Mohamed wrote: Hehe, ok.. I don't know either but I took some

Re: [GENERAL] chinese parser for text search !

2009-02-02 Thread Oleg Bartunov
nlpbamboo, it fails. Has one of you tried (and succeeded) to use Tsearch for Chinese? Thanks for your attention, Daniel Oleg Bartunov a ?crit : Hi there, there is a chinese parser for tsearch2 available from http://code.google.com/p/nlpbamboo/wiki/TSearch2 under BSD license. It'd be nice

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Oleg Bartunov
. Have that index been built up using the dictionary/configuration, or is the dictionary only used on search frases? / Moe Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru

Re: [GENERAL] Full text index not being used

2009-02-01 Thread Oleg Bartunov
characters are ignored. ERROR: index row requires 13356 bytes, maximum size is 8191 Any ideas about how to resolve this? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru

Re: [GENERAL] Text search segmentation fault

2009-01-29 Thread Oleg Bartunov
] [pgtest02] [:] [] [12023] [0] LOG: autovacuum launcher started [2009-01-29 13:55:12.011 CET] [pgtest02] [:] [] [26466] [0] LOG: database system is ready to accept connections Regards, Oleg _ Oleg Bartunov

Re: [GENERAL] Text search name and name synonims dictionary

2009-01-29 Thread Oleg Bartunov
of dictionary, to know, what to google for? http://yandex.ru/yandsearch?text=словарь+личных+имен Thanks in advance, and regards Igor Katson. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

[GENERAL] need contact in Nepal

2009-01-29 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83

Re: [GENERAL] very long update gin index troubles back?

2009-01-28 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Text search with ispell

2009-01-27 Thread Oleg Bartunov
. Where did you get them ? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [GENERAL] Text search with ispell

2009-01-27 Thread Oleg Bartunov
Have you read http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY We suggest to use dictionaries which come with openoffice, hunspell, probably has better support of composite words. On Tue, 27 Jan 2009, Tommy Gildseth wrote: Oleg Bartunov

Re: [GENERAL] Text search with ispell

2009-01-27 Thread Oleg Bartunov
On Tue, 27 Jan 2009, Tommy Gildseth wrote: Tommy Gildseth wrote: Oleg Bartunov wrote: Have you read http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY We suggest to use dictionaries which come with openoffice, hunspell, probably has

Re: [GENERAL] Text search with ispell

2009-01-27 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83

Re: [GENERAL] very long update gin index troubles back?

2009-01-24 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83

Re: [GENERAL] Initial ugly reverse-translator

2009-01-15 Thread Oleg Bartunov
, Oleg Bartunov o...@sai.msu.su wrote: On Sat, 19 Apr 2008, Tom Lane wrote: Craig Ringer cr...@postnewspapers.com.au writes: Tom Lane wrote: I don't really see the problem. I assume from your reference to pg_trgm that you're using trigram similarity as the prefilter for potential matches

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-05 Thread Oleg Bartunov
indexes over the two dictionaries or should I split them ? if arabic and english characters are not overlaped, you can use one index. For example, for english/russian text we have one index Regards, Oleg _ Oleg

Re: [GENERAL] Fulltext index

2008-11-08 Thread Oleg Bartunov
: Zugriffsmethode ЪЪginЪЪ unterstЪЪtzt keine mehrspaltigen Indexe SQL state: 0A000 means, gin doesn't accept multicolumn indexes. Any ideas? Greetings Andreas Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

Re: [GENERAL] gin index creation performance problems

2008-11-03 Thread Oleg Bartunov
it as a buffer and you can save a lot of IO. All this written in the documentation and there are other parameters you should be concerned about. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

[GENERAL] chinese parser for text search !

2008-11-02 Thread Oleg Bartunov
, we unable to verify this parser, so I'm asking about help. We need usual extensive testing (memory leaking, portability, etc), regression test and patch for documentation. Regards, Oleg _ Oleg Bartunov, Research

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Oleg Bartunov
with slashes are interpreted as file paths and the first path is beeing dropped. any idea how we can fix this? jodok Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Oleg Bartunov
Sergio, On Fri, 31 Oct 2008, Ivan Sergio Borgonovo wrote: On Fri, 31 Oct 2008 13:10:20 +0300 (MSK) Oleg Bartunov [EMAIL PROTECTED] wrote: Jodok, you got what's you defined. Please, read documentation. In short, word doesn't indexed if it is not recognized by any dictionaried from stack

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Oleg Bartunov
On Fri, 31 Oct 2008, Jodok Batlogg wrote: hi oleg, thanks for your quick response, 2008/10/31 Oleg Bartunov [EMAIL PROTECTED]: Jodok, you got what's you defined. Please, read documentation. In short, word doesn't indexed if it is not recognized by any dictionaried from stack of dictionaries

Re: [GENERAL] Question about fulltext search and to_tsvector function

2008-10-17 Thread Oleg Bartunov
_ 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)939-23-83 -- Sent

[GENERAL] drupal 6.x fixes for PostgreSQL 8.3 available

2008-10-11 Thread Oleg Bartunov
_ 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)939-23-83 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] tsearch2 query

2008-10-02 Thread Oleg Bartunov
() for *ALL* results, while you need to do this only for 20 of them. Feel the difference ? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow

Re: [GENERAL] tsearch 2 query

2008-10-02 Thread Oleg Bartunov
on stories (cost=0.00..90.14 rows=20 width=623) (actual time=700.633..63243.713 rows=680 loops=1) Index Cond: (stories.vectors @@ outer.q) Total runtime: 74847.177 ms Regards, Oleg _ Oleg Bartunov

Re: [GENERAL] PostgreSQL Cache

2008-09-29 Thread Oleg Bartunov
is to reboot the whole server. -- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical

Re: [GENERAL] Is there bigintarray?

2008-09-13 Thread Oleg Bartunov
[]. We have item in our TODO list http://www.sai.msu.su/~megera/wiki/TODO GiSTarray - intarray for all built-in data types - 1 week Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru

Re: [GENERAL] TSearch2: find a QUERY that does match a single document

2008-09-12 Thread Oleg Bartunov
' is the number of estimated rows, which is not good, since you got only 1 row. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University

Re: [GENERAL] Case sensitive full text searching

2008-09-03 Thread Oleg Bartunov
, Mario Barcala P.S. I am using PostgreSQL 8.3 Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL

Re: [GENERAL] Text search configuration

2008-09-02 Thread Oleg Bartunov
_ 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)939-23-83 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Using ISpell dictionary - headaches...

2008-07-22 Thread Oleg Bartunov
dictionary installation is detailed step by step so that I can check if I did something wrong somewhere... Many thanks for your attention, Daniel Chiaramello Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

Re: [GENERAL] ER diagram software

2008-07-22 Thread Oleg Bartunov
and has trial period. Thanks. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED], http

Re: [GENERAL] Optimizing a like-cause

2008-07-22 Thread Oleg Bartunov
to speed up the Statement? What Index can I set? Thanks for your Help, Stefan Sturm Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow

Re: [GENERAL] Full text index without accents

2008-07-22 Thread Oleg Bartunov
. Is it the only way to do it to develop another .c and write my own dict_noaccent.c, and then compile and install it into the system? Regars, Mario Barcala Regards, Oleg _ Oleg Bartunov, Research Scientist

Re: [GENERAL] tsearch dictionary list?

2008-07-18 Thread Oleg Bartunov
tsearch dictionaries? Are japanese, chinese, or other exotic languages supported by tsearch? Thanks for your attention, Daniel Chiaramello Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

Re: [GENERAL] Inconsistency with stemming/stop words in Tsearch2

2008-07-15 Thread Oleg Bartunov
) or doesn't contain lexeme(s), ignored Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED

Re: [GENERAL] changing text search treatment of puncutation

2008-07-03 Thread Oleg Bartunov
_ 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)939-23-83 -- Sent via

Re: [GENERAL] Full text index without accents

2008-07-03 Thread Oleg Bartunov
_ 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)939-23-83 -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] FTS question

2008-07-01 Thread Oleg Bartunov
. prefix search support will be supported in 8.4. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL

Re: [GENERAL] multi-word expression full-text searching

2008-07-01 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)939

Re: [GENERAL] tsearch strategy for incremental search

2008-06-30 Thread Oleg Bartunov
Pierre, you, probably, can use custom configuration, which uses pg_3chars dictionary. Oleg On Mon, 30 Jun 2008, Pierre Thibaudeau wrote: 2008/6/30 Oleg Bartunov [EMAIL PROTECTED]: tsearch will have prefix search support in 8.4. Thanks Oleg! That's fantastic news! In the meantime

Re: [GENERAL] tsearch strategy for incremental search

2008-06-30 Thread Oleg Bartunov
On Mon, 30 Jun 2008, Pierre Thibaudeau wrote: 2008/6/30 Oleg Bartunov [EMAIL PROTECTED]: you, probably, can use custom configuration, which uses pg_3chars dictionary. Thanks Oleg. That sounds like a cleverer (and more natural) idea than mine. I am intrigued: is pg_3chars something that's

Re: [GENERAL] HTML tags and tsearch2

2008-06-26 Thread Oleg Bartunov
or pointers to further reading on how I might do this. (I am using PostgreSQL version 8.1.10) think about upgrading to 8.3 Many thanks in advance, Joanna Regards, Oleg _ Oleg Bartunov, Research Scientist

Re: [GENERAL] Full Text Search

2008-04-25 Thread Oleg Bartunov
dictionaries ? If yes what kind (for english for example) ? something like dict_regex ? http://vo.astronet.ru/arxiv/dict_regex.html TY Best. andy Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

<    1   2   3   4   5   >