Re: Index does not working.

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Dan Black <fireworker(at)gmail(dot)com>
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index does not working.
Date: 2005-06-13 18:47:49
Message-ID: m27jgyxfe2.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dan Black <fireworker(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-06-13 19:10:41 Re: pg_dumpall not working?
Previous Message David Siebert 2005-06-13 18:39:15 pg_dumpall not working?