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