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

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 @@

[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 bod