Обсуждение: re : Re: Very long running query
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 Cheers , PEJAC Pascal
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
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 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@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