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