Re: Postgres 8.3 is not using indexes

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Clemens Schwaighofer" <cs(at)tequila(dot)co(dot)jp>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 8.3 is not using indexes
Date: 2008-08-14 11:33:47
Message-ID: 87skt7u8ys.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Clemens Schwaighofer" <cs(at)tequila(dot)co(dot)jp> writes:

> Any tips why this is so?

They don't appear to contain the same data.
If they do have you run analyze recently?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Teslenko 2008-08-14 11:48:49 Re: Strange query plan
Previous Message Peter Eisentraut 2008-08-14 11:30:37 Re: Strange query plan