In <200104120845.f3C8jM806217@postgresql.org> <pejac@altern.org> writes:
>The query explain see that your query don't use
>index, so have you create index on Netscapereduce(url) and websensebycat (url) ????
>If you have already create this index , for optimizer
>to use index with SEQ_SCAN OFF
That was what I thought creating extra indexes. I will try this.
Thanks,
Konstantin
>Cheers ,
>PEJAC Pascal
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres