Re: : Re: Very long running query

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