"Kristian Eide" <kreide(at)online(dot)no> writes:
> Why do postgre think it will get over 46k rows from this query?
Not sure (and you didn't give the pg_statistic data that might tell us
why). But it's no longer a very interesting question; we will not be
fixing 7.1 optimizer bugs anymore. Please try it in 7.2 and see if you
get better results.
regards, tom lane