Re: [SQL] tsearch2 and wildcards/pattern matching?

in tsearch2 that can do this and is faster than LIKE clauses on full-text, that would be fantastic. Cheers, Peter Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg

Re: [SQL] Full text search ordering question

/ Regards, 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

Re: [SQL] Full Text Index Stats

! Regards, 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

Re: [SQL] tsearch2: ts_headline performance problem

)--- TIP 2: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet

Re: [SQL] Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?

dictionary. Search archives ! Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED], http

Re: [SQL] tesearch2 question

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

Re: [SQL] tesearch2 question

in psql before executing update command. Then you could estimate total time. The server is Sun OS 5.10, with around 8gigs of RAM and 6cpus. Thanks, Sumeet. On 3/7/07, Oleg Bartunov oleg@sai.msu.su wrote: On Wed, 7 Mar 2007, Sumeet wrote: Hi All, I'm trying to udpate a table containing

Re: [SQL] GiST index question: performance

to install compiled module to your database. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su

Re: [SQL] GiST index question: performance

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

Re: [SQL] Very large IN-clause is slow, but how to rewrite it?

of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Regards, Oleg _ Oleg Bartunov

Re: [SQL] simple web search

at http://www.postgresql.org/about/donate Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet

Re: [SQL] simple web search

. Thanks Joe, I initially wanted to avoid dipping my toe into tsearch2 but it might be what I need after all :) Don't be afraid, it's not so difficult to start. Regards, Oleg _ Oleg Bartunov, Research Scientist

Re: [SQL] Efficient Searching of Large Text Fields

://www.postgresql.org/docs/faq Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su

Re: [SQL] Efficient Searching of Large Text Fields

)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute

Re: [SQL] Like with special character

)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg

Re: [SQL] Reverse Index ... how to ...

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

Re: [SQL] assorted problems with intarray and other GiST contribs.

, 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

Re: [SQL] Set Membership operator -- test group membership

to [EMAIL PROTECTED]) Regards, 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

Re: [SQL] tsearch2

this is a pg error, not tsearch2 -- do you know of any workarounds? upgrade your postgresql Thanks for all your help Oleg, Dan - Original Message - From: Oleg Bartunov oleg@sai.msu.su To: Dan Feiveson [EMAIL PROTECTED] Sent: Monday, April 18, 2005 10:13 PM Subject: Re: [SQL] tsearch2 On Mon, 18 Apr

Re: [SQL] tsearch2

again for all your help, Dan Dan Feiveson DataJoe LLC Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http

Re: [SQL] OpenFTS

problems installing? Any drawbacks? Many thanks to anyone with the time to respond, Dan Dan Feiveson Broomfield, Colorado Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute

Re: [SQL] How to store directory like structures?

to the mailing list cleanly Regards, 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

Re: [SQL] How to store directory like structures?

, AXEL. Regards, 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

Re: [SQL] How to store directory like structures?

idea? you need to load ltree into your database ! psql yourdb ltree.sql use 'locate ltree.sql' to find if ltree is installed Thanks, AXEL. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet

Re: [SQL] datediff is there something like it?

copies of the original message, including attachments. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su

Re: [SQL] tree structure photo gallery date quiery

_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [SQL] tree structure photo gallery date quiery

On Wed, 17 Nov 2004, Achilleus Mantzios wrote: O Oleg Bartunov ?? Nov 17, 2004 : Gary, if you need really fast solution for you task and dont't afraid non-standard soltion, take a look on contrib/ltree module. http://www.sai.msu.su/~megera/postgres/gist/ltree/ Oleg Oleg how would you

Re: [SQL] Compare strings which resembles each other

On Fri, 21 Nov 2003, Ian Barwick wrote: On Friday 21 November 2003 15:32, Oleg Bartunov wrote: On Fri, 21 Nov 2003, Christoph Haller wrote: $PGSQLD/contrib/tsearch/README.tsearch is your friend. I think tsearch(2) isn't what Gulshan need. He needs fuzzy search, there are several

Re: [SQL] search facilities

---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org Regards, Oleg _ Oleg Bartunov, sci.researcher

Re: [SQL] GiST and full text search

/ tsearch2 in the contrib/ directory? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings Regards, Oleg _ Oleg Bartunov

Re: [SQL] Select Match on PostgreSQL.

Churchill 25 000 Besanon ___ Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia

Re: [SQL] SELECT IN Still Broken in 7.4b

_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [SQL] Join table with itself for heirarchial system?

)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg

Re: [SQL] relevance

to the mailing list cleanly Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su

Re: [SQL] sort by relevance

, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939

Re: [SQL] Proposal of hierarchical queries, a la Oracle

]) 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: +007(095)939-16-83

Re: [SQL] rows in order

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: +007(095)939-16-83, +007(095

Re: [SQL] expressions operating on arrays

on the contents of an array ? Thanks, John Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED

Re: [SQL] expressions operating on arrays

, '{removeme}') where t.text *= removeme; -- ?? thx, John On Fri, 9 Aug 2002, Oleg Bartunov wrote: Look at contrib/intarray. You'll get an index access as a bonus Oleg On Fri, 9 Aug 2002, Achilleus Mantzios wrote: look at /usr/local/src/postgresql-7.2.1/contrib/intarray

Re: [SQL] retrieving all rows from a tree in one select - how ?

little time at all. Adam Erickson ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Regards, Oleg _ Oleg Bartunov

Re: [SQL] graphical interface - admin

_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [SQL] graphical interface - admin

(I only get Oracle and MySQL in the combo-box even though its staticly linked with pgsql). How did you configure sources ? There is no --with-pgsql option Regards, Oleg _ Oleg Bartunov, sci.researcher

Re: [SQL] How to enter lists into database.

. San Francisco 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

Re: [SQL] loading array_iterator.so does not work with Postgresql

://archives.postgresql.org Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera

Re: [SQL] RTREE on points

_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [SQL] RTREE on points

On Tue, 17 Apr 2001, Jeff Hoffmann wrote: Oleg Bartunov wrote: GiST is great ! You may look at http://www.sai.msu.su/~megera/postgres/gist/ for GiST implementation of RTree - it could be not compiled with 7.1 release due to some api changes, but it's not difficult to do. it looks

[SQL] help with query

messages which parent is MSG_ID. (hmm, probably I have to get this example as (parent, child) example) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

Re: [SQL] Weighted Searching

ideas, please drop me an email.. Thanks!!! -Mitch _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera

[SQL] need asap: bg_BG locale for FreeBSD

. The only thing I found is bg_BG locale for Linux (Redhat) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED