Re: [GENERAL] Slow search.. quite clueless

2005-09-26 Thread Yonatan Ben-Nes
Oleg Bartunov wrote: On Mon, 26 Sep 2005, Yonatan Ben-Nes wrote: Hi again everyone, Oleg I tried tsearch2 and happily it does work wonderfully for me returning results extremly fast and actually its working even better then I wanted with all of those neat features like: lexem, weight & stop

Re: [GENERAL] Slow search.. quite clueless

2005-09-26 Thread Oleg Bartunov
On Mon, 26 Sep 2005, Yonatan Ben-Nes wrote: Hi again everyone, Oleg I tried tsearch2 and happily it does work wonderfully for me returning results extremly fast and actually its working even better then I wanted with all of those neat features like: lexem, weight & stop words. I got only on

Re: [GENERAL] Slow search.. quite clueless

2005-09-26 Thread Yonatan Ben-Nes
Oleg Bartunov wrote: contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ) might works for you. It might because performance depends on cardinality of your keywords. Oleg On Tue, 20 Sep 2005, Yonatan Ben-Nes wrote: Hi all, Im building a site where the users can s

Re: [GENERAL] Slow search.. quite clueless

2005-09-23 Thread Yonatan Ben-Nes
Gábor Farkas wrote: Yonatan Ben-Nes wrote: Dawid Kuroczko wrote: Hmm, JOIN on a Huge table with LIMIT. You may be suffering from the same problem I had: http://archives.postgresql.org/pgsql-performance/2005-07/msg00345.php Tom came up with a patch which worked marvellous in my case: http:

Re: [GENERAL] Slow search.. quite clueless

2005-09-22 Thread Gábor Farkas
Yonatan Ben-Nes wrote: Dawid Kuroczko wrote: Hmm, JOIN on a Huge table with LIMIT. You may be suffering from the same problem I had: http://archives.postgresql.org/pgsql-performance/2005-07/msg00345.php Tom came up with a patch which worked marvellous in my case: http://archives.postgresql.o

Re: [GENERAL] Slow search.. quite clueless

2005-09-22 Thread Yonatan Ben-Nes
Dawid Kuroczko wrote: On 9/20/05, *Yonatan Ben-Nes* <[EMAIL PROTECTED] > wrote: Hi all, Im building a site where the users can search for products with up to 4 diffrent keywords which all MUST match to each product which found as a result to the search

Re: [GENERAL] Slow search.. quite clueless

2005-09-21 Thread Dawid Kuroczko
On 9/20/05, Yonatan Ben-Nes <[EMAIL PROTECTED]> wrote: Hi all,Im building a site where the users can search for products with up to 4diffrent keywords which all MUST match to each product which found as aresult to the search.I got 2 tables (which are relevant to the issue :)), one is the product ta

Re: [GENERAL] Slow search.. quite clueless

2005-09-21 Thread Yonatan Ben-Nes
Olly Betts wrote: Yonatan Ben-Nes wrote: Actually I even started to look on other solutions and maybe you can say something about them also.. maybe they can help me: 1. Omega (From the Xapian project) - http://www.xapian.org/ You could certainly do this with Xapian and Omega. With only 5 mi

Re: [GENERAL] Slow search.. quite clueless

2005-09-21 Thread Yonatan Ben-Nes
Oleg Bartunov wrote: On Tue, 20 Sep 2005, Philip Hallstrom wrote: contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ) might works for you. It might because performance depends on cardinality of your keywords. Seconded. We use tsearch2 to earch about 40,000 rows con

Re: [GENERAL] Slow search.. quite clueless

2005-09-21 Thread Olly Betts
Yonatan Ben-Nes wrote: > Actually I even started to look on other solutions and maybe you can say > something about them also.. maybe they can help me: > 1. Omega (From the Xapian project) - http://www.xapian.org/ You could certainly do this with Xapian and Omega. With only 5 million records it s

Re: [GENERAL] Slow search.. quite clueless

2005-09-20 Thread Oleg Bartunov
On Tue, 20 Sep 2005, Philip Hallstrom wrote: contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ) might works for you. It might because performance depends on cardinality of your keywords. Seconded. We use tsearch2 to earch about 40,000 rows containing manufacturer,

Re: [GENERAL] Slow search.. quite clueless

2005-09-20 Thread Philip Hallstrom
contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ) might works for you. It might because performance depends on cardinality of your keywords. Seconded. We use tsearch2 to earch about 40,000 rows containing manufacturer, brand, and product name and it returns a result

Re: [GENERAL] Slow search.. quite clueless

2005-09-20 Thread Alex Turner
I"m by no means an expert on this, and perhaps someone with more knowledge can help, but it looks to me like the planner estimate and the actual cost are significantly different which to me means that an analyze is required, or/and increase the stats on these tables would be usefull.  Also I'm wond

Re: [GENERAL] Slow search.. quite clueless

2005-09-20 Thread Oleg Bartunov
contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ) might works for you. It might because performance depends on cardinality of your keywords. Oleg On Tue, 20 Sep 2005, Yonatan Ben-Nes wrote: Hi all, Im building a site where the users can search for products