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

;; I've been unable to find anything in documentation. If there's anything in tsearch2 that can do this and is faster than LIKE clauses on full-text, that would be fantastic. Cheers, Peter Regards, Oleg _

Re: [SQL] Full text search ordering question

Goblin'! - http://www.pricegoblin.co.uk/ Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PRO

Re: [SQL] Full Text Index Stats

rite it myself? Thanks! Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED], http://www.

Re: [SQL] tsearch2: ts_headline performance problem

erly. Alternately, are there any alternatives to the ts_headline function? Sincerely, Anders ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster Regards, Oleg _

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

uld be done with tsearch using substring dictionary. Search archives ! Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Int

Re: [SQL] tesearch2 question

t issue \timing 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 wrote: On Wed, 7 Mar 2007, Sumeet wrote: > Hi All, > > I'm trying to udpate

Re: [SQL] tesearch2 question

SERNAME LWP PRI NICE SIZE RES STATETIMECPU COMMAND 3091 postgres 1 430 46M 38M cpu/1 200:06 3.20% postgres 5052 postgres 1 600 149M 134M sleep0:17 3.12% postgres << Regards, Oleg _

Re: [SQL] GiST index question: performance

with such rights 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 Inter

Re: [SQL] GiST index question: performance

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: oleg@sai.

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

= 10)) (8 rows) ---(end 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 _

Re: [SQL] simple web search

arch2. 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, Res

Re: [SQL] simple web search

: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternber

Re: [SQL] Efficient Searching of Large Text Fields

On Wed, 14 Jun 2006, Achilleus Mantzios wrote: O Oleg Bartunov ?? Jun 14, 2006 : Don't invent a wheel and use contrib/tsearch2 for that. Hi Oleg, i just wanted to ask if anything close to exact phrase matching could be deployed/implemented with tsearch2. not yet, but d

Re: [SQL] Efficient Searching of Large Text Fields

end of broadcast)--- 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 Astron

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 Astron

Re: [SQL] Like with special character

dcast)--- 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:

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

e map settings 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: +007(495)939-16-83, +007(495)

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

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] Set Membership operator -- test group membership

mand (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [email protected]

Re: [SQL] tsearch2

d suggests 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" To: "Dan Feiveson" <[EMAIL PROTECTED]> Sent: Monday, April 18, 2005 10:13 PM Subject

Re: [SQL] tsearch2

search2? Thanks 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@s

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?

does not exist Any 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.resear

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

compile by hand ? Thanks, AXEL. Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [email protected], http://www.sai.msu.su/~meger

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

message can get through to the mailing list cleanly Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [email protected], http

Re: [SQL] New record position

amin Brazil ---(end of broadcast)--- TIP 8: explain analyze is your friend Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (

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

ded recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNe

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 woul

Re: [SQL] tree structure photo gallery date quiery

tween p2.lft and p2.rgt and p2.id = gallery_id ); return pcount; end' language 'plpgsql'; Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow Univer

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&

Re: [SQL] Compare strings which resembles each other

-- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > Regards, Oleg ___

Re: [SQL] search facilities

d junk mail protection with MSN 8. > http://join.msn.com/?page=features/junkmail > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org > Regards,

Re: [SQL] GiST and full text search

--(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow U

Re: [SQL] Select Match on PostgreSQL.

ience : >http://www.wysistat.com > > Tel : 03 81 48 03 13 > Fax : 03 81 48 04 83 > >16, Boulevard Winston Churchill > 25 000 BesanГon > ___ >

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

;t forget to increase your free space map settings > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.

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

ally for id #1 (Clothing) and since parent ==0 I stop. > > This seems wasteful - can this be done in a single query? > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faqs/FAQ.h

Re: [SQL] relevance

rough Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > Regards, Oleg _ Oleg Bartunov, sci.researc

Re: [SQL] sort by relevance

tsearch though. > 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)9

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

I see. > > regards, > --- > .evgen > > On Sat, 16 Nov 2002, Oleg Bartunov wrote: > > > Evgen, > > > > read info about ltree module > > http://www.sai.msu.su/~megera/postgres/gist/ltree/ > > > > Do you have implemented indexed access ? > &g

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

i understand problem > is in pg's sort. it's not a bug but feature of sort alghorithm. > > The minor problem is that such tree a bit difficult to maintain. for ex. if i need > to move some node to elsewhere in tree, i need to update all childs, sub > childs, ... of this node

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

he unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

Re: [SQL] rows in order

t)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institu

Re: [SQL] tree structures in sql - my point of view (with request

t; - fetching childs > - fetching "from id up" > - fetching "from id down" > also when you need to get indirect parents/childs or when you need only > some of the data (from me, up, but not more then to my > grand-grand-grand-father). > > i'd li

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

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

Re: [SQL] expressions operating on arrays

d=g_int_union(t.id, '{555}') where t.id *= 444; -- ?? > update t set text=g_int_picksplit(t.text, '{"removeme"}') where t.text *= >"removeme"; -- ?? > > thx, > > John > > On Fri, 9 Aug 2002, Oleg Bartunov wrote: > > > Look at contr

Re: [SQL] expressions operating on arrays

est1 where array1 CONTAINS > '567' UNION select '789'); > > > How do I go about expressing and operating on the contents of an array ? > > > Thanks, > >John > > Regards, Oleg

Re: [SQL] Ltree usage..

Qry3 are equvalent and Qry3 is faster but not much. But Qry1 is not the same as Qry2 !!! Qry1 could be rewritten as: SELECT path from unified_data where path @ '180 & 1'; > > also is qry3 better to Qry2 in terms of performance? > > regds > mallah. > > >

Re: [SQL] graphical interface - admin

remove your $HOME/.qt dir. > > I have not gotten the newer version(1.3.5.1) to work with PostgreSQL(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 > > Rega

Re: [SQL] graphical interface - admin

s, 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

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

) 565-7293 > for law firms, small businessesfax 621-2533 > and non-profit organizations. San Francisco > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Stern

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

cast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astr

Re: [SQL] RTREE on points

Jeff, I checked the archive and it works with 7.1 release we've implemented only several functions for box, so you may use them as example for remaining types. Regards, Oleg On Wed, 18 Apr 2001, Oleg Bartunov wrote: > On Tue, 17 Apr 2001, Jeff Hoffmann wrote: &g

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 ap

Re: [SQL] RTREE on points

g it, if for no > other reason than to be able to test if the feature even works. > > Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University

[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] Arrays

--- > Albert Reiner <[EMAIL PROTECTED]> > Deutsch * English * Esperanto * Latine > -- > ___

Re: [SQL] Weighted Searching

t they > wouldn't necessarily have to be in Arizona (because our minimum weight is > 20, only two would have to match).. > > Hopefully I'm not over-explaining to the point of confusion.. If anyone > would have any ideas, please drop me an email.. Thanks!!! > > -Mitch

Re: [SQL] need asap: bg_BG locale for FreeBSD

Palle Girgensohn <[EMAIL PROTECTED]> > To: Oleg Bartunov <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Re: [SQL] need asap: bg_BG locale for FreeBSD > > Oleg Bartunov wrote: > > > > Hi, > > > > I'm going to Bulgar

[SQL] need asap: bg_BG locale for FreeBSD

ation. 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