[HACKERS] slow count() was: tsearch2 poor performance

2004-10-03 Thread Oleg Bartunov
On Fri, 1 Oct 2004, Kris Kiger wrote: Hey all, its me again. If I do not do a count(product_id) on my tsearch2 queries, its actually really fast, for example; Hmm, I also really want to know what's the difference ? Postgresql 8.0beta3 on Linux 2.4.25 tsearchd=# explain analyze select body

Re: [HACKERS] slow count() was: tsearch2 poor performance

2004-10-03 Thread Magnus Hagander
Hey all, its me again. If I do not do a count(product_id) on my tsearch2 queries, its actually really fast, for example; Hmm, I also really want to know what's the difference ? Postgresql 8.0beta3 on Linux 2.4.25 tsearchd=# explain analyze select body from txt where fts_index @@

Re: [HACKERS] slow count() was: tsearch2 poor performance

2004-10-03 Thread Oleg Bartunov
Magnus On Sun, 3 Oct 2004, Magnus Hagander wrote: Hey all, its me again. If I do not do a count(product_id) on my tsearch2 queries, its actually really fast, for example; Hmm, I also really want to know what's the difference ? Postgresql 8.0beta3 on Linux 2.4.25 tsearchd=#