Re: Strange runtime partition pruning behaviour with 11.4
Thomas Kellerer <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
> 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