Postgres Pro
Downloads
Home   >   mailing lists

Re: index problem (uses one index but not the other) - Mailing list pgsql-general

From Tom Lane
Subject Re: index problem (uses one index but not the other)
Date
Msg-id 9810.1018936158@sss.pgh.pa.us
Whole thread Raw
In response to index problem (uses one index but not the other)  (Maurice Balick <balm@smiley.com>)
List pgsql-general
Tree view 
Maurice Balick <balm@smiley.com> writes:
> The weird thing is that this used to work (i.e. trans_oid_idx was used)
> when there was about 200000 records (about 1/3 of now). Also, there is
> about
> 9000 distinct values of account_id, but about 300000 values of order_id.

What's the most common value in each case?

> (I am running Postgresql 7.1.3 on Redhat 7.1)

7.2 is less likely to be fooled when the most common value is much more
common than the rest ...

            regards, tom lane

pgsql-general by date:

Previous
From: Maurice Balick
Date:
Subject: index problem (uses one index but not the other)
Next
From: Mark Price
Date:
Subject: j2sdk1.4.0 jdbc compile errors