Postgres Pro
Downloads
Home   >   mailing lists

Re: Index does not working. - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Index does not working.
Date
Msg-id m27jgyxfe2.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Index does not working.  (Dan Black <fireworker@gmail.com>)
Responses Re: Index does not working.  (Dan Black <fireworker@gmail.com>)
List pgsql-general
Tree view 
Dan Black <fireworker@gmail.com> writes:

> First query does not use index in contrast to two query.
>
> Why?

You don't give enough information.  Post EXPLAIN ANALYZE output for
both queries and perhaps someone can help.

-Doug

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dumpall not working?
Next
From: jao@geophile.com
Date:
Subject: Will the optimizer eliminate an unnecessary sort?