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

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