> it's posible to rewrite the query to:
>
>
> test=# explain analyse select count(*) from foo_bar_baz as fbb where foo_id = (select foo_id from foo where foo_name = 'eeny');
>
> I know, that's not a solution, but a workaround. :-(
Yes, I discovered that as well.
But I'm more confused (or concerned) by the fact that the (original) query works correctly *without* statistics.
Thomas