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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.