Re: : Re: Very long running query

In <200104120845(dot)f3C8jM806217(at)postgresql(dot)org> <pejac(at)altern(dot)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
Thanks that was it instead of infinite just a few seconds... My fate in Postgres
has been restored \:)

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(at)postgresql(dot)org)

--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres