| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | T(dot)R(dot)Missner(at)Level3(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how to speed query |
| Date: | 2001-09-17 14:01:19 |
| Message-ID: | 20010918000119.A23604@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Sep 14, 2001 at 02:05:18PM -0600, T(dot)R(dot)Missner(at)Level3(dot)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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herbert Liechti | 2001-09-17 14:01:32 | Re: how to speed query |
| Previous Message | Chris Boyle | 2001-09-17 11:51:40 | Re: NewYork Bombing: SQL server bomb proof!! |