mnogosearch -- pgsql seem so slow, please help me 
Author Message
 mnogosearch -- pgsql seem so slow, please help me

I'm using hte mod_perl version ... with a database of some 12million words
... except with the database under load with a vacuum or some such, I
dont' find that the search is too slow ... would like to somehow get rid
of that LIKE clause, which would probably spee d thing sup some, but going
from search.c to search.mpl mae a world of difference here ...

Quote:



> > > 'select * from url' from psql monitor took 59 seconds.

> > How big is the table?  Your EXPLAIN mentions 99256 rows, but I can't
> > tell if that stat is up-to-date or not.

> it is 99256. i don't think it's that big of a table is it? typically the
> query under mnogo takes less than a second, at most a couple seconds but
> not 50+ secs.

> maybe Hermit has some input as he runs it for postgresql.org's search.

> > A select like that is going to be pretty much all data transfer: read
> > the disk blocks, format the data values, send 'em to the frontend.
> > There's hardly anything that Postgres can do to optimize or pessimize
> > it.  You might shave a few milliseconds by using a binary cursor (to
> > avoid formatting the integer values into ASCII) but probably not a lot.

> > If you've done a whole lot of UPDATEs/DELETEs on the table since your
> > last VACUUM, then reading empty disk blocks might be costing you some
> > time.

> i did vacuum analyze.

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy




Wed, 02 Jul 2003 01:55:19 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. mnogosearch -- pgsql seem so slow, please help me find out why

2. mnogosearch -- pgsql seem so slow, please help me find out why

3. seems lost connection, please help

4. seems lost connection, please help

5. Jobs seem to lock....help please

6. seems lost connection, please help

7. PLEASE HELP - cursor doesn't seem to sort properly

8. COMBO BOX, PLEASE HELP, PLEASE HELP, PLEASE HELP!

9. ADO in VB seems slow to update

10. Program seems slow

11. Enterprise Manager seems slow

12. Sparc seems very slow


 
Powered by phpBB® Forum Software