Home > mailing lists

re : Re: Very long running query - Mailing list pgsql-general

From
Subject	re : Re: Very long running query
Date	April 12, 2001 07:58:42
Msg-id	200104120845.f3C8jM806217@postgresql.org Whole thread Raw
List	pgsql-general

Tree view

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

pgsql-general by date:

From: will trillich
Date: 12 April 2001, 05:19:05
Subject: Re: System tables

From: Tony Grant
Date: 12 April 2001, 08:07:40
Subject: Re: ongoing holy grail thread

re : Re: Very long running query - Mailing list pgsql-general

Previous

Next