Thanks!
I've added this into pgsql create script.
Caffeinate The World wrote:
>
> 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]
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
