mnogosearch-cvs, postgresql-cvs
i just wanted to let everyone who uses postgresql with mnogosearch how
i got this incredible speed increase. I had about 500,000 URLs and when
i started indexing, it took for ever between each URL. per alex's
suggestion, i turned on debugging for sql.c and found where it took the
most time. a query like below took about 38 secs before i created the
index, now takes less than 1 sec between urls.
[13289] SQL 0.26s: SELECT rec_id FROM url WHERE crc32=40757896 AND
status=200 AND docsize=10927
i created the index:
CREATE INDEX url_crc32_status_docsize ON url (crc32,status,docsize)
perhaps this can be added to the create.txt file for postgresql.
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
