On Sat, 2003-04-19 at 22:36, kp wrote:
> The other difference between these two columns (or rather the kind of
> data they contain) is that the column for which postgres *uses* the
> index on contains around 32000 distinct values while the other only
> contains 14 distinct values.
Did you do a vacuum analyze on the tables in question? There are some
other more complex possibilities, but best to start w/ the basics.
--
Tim Ellis
Senior Database Architect and author, tedia2sql (http://tedia2sql.tigris.org)
If this helped you, http://svcs.affero.net/rm.php?r=philovivero