Re: how to speed query - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: how to speed query
Date
Msg-id 20010918000119.A23604@svana.org
Whole thread Raw
In response to how to speed query  (T.R.Missner@Level3.com)
List pgsql-general
On Fri, Sep 14, 2001 at 02:05:18PM -0600, T.R.Missner@Level3.com wrote:
> the query simply asks for all callids between 2 times.
> I have an index on the time column but it doesn't get used.
> Is there a better way for me to be doing this?
> Seems so simple.

Have you done a vacuum analyze? Can you show us the explain of the query.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.

pgsql-general by date:

Previous
From: peace_flower
Date:
Subject: MySQL development MUST immdediately cease - Due to GlobalEconomic condition..
Next
From: Doug McNaught
Date:
Subject: Re: Transition from MS-SQL - Store Procedures?