--- Alexander Barkov <[EMAIL PROTECTED]> wrote:
> 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.
> >
>
>
> Btw, does index on the only one crc32 field help?
> It uses less space and should be as faster as your one.
i just tested using only an index on crc32 and on average it took about
32.0 seconds. so it isn't as fast as my original (larger) index above
(0.26 sec).
__________________________________________________
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]
