Re: mnogosearch -- pgsql seem so slow, please help me find out why

On Thu, 11 Jan 2001, Thomas T. Thai wrote:

> pgsql 7.1-current, mnogosearch-3.1.8, netbsd/alpha-1.5.1-current, dec
> alpha 500, 1G ram, uw-scsi
>
> i'm trying to find out why postgres is the bottle neck in my searches with
> mnogosearch. i've tried both the search.c and php version of search and
> they both took up to 50 seconds for a one word search. this is with the
> system sitting pretty much idle.
>
> 'select * from url' from psql monitor took 59 seconds.
>
> mnwork=# explain select * from url;
> NOTICE: QUERY PLAN:
>
> Seq Scan on url (cost=0.00..14473.56 rows=99256 width=144)
>
> EXPLAIN

Unless there is a WHERE clause to work with, it will always return all
rows, and always use a SeqSearch ...