Re: Strange runtime partition pruning behaviour with 11.4 - Mailing list pgsql-performance

From Thomas Kellerer
Subject Re: Strange runtime partition pruning behaviour with 11.4
Date
Msg-id 9c55d578-bb70-d439-6450-abc291957ec3@gmx.net
Whole thread Raw
In response to Re: Strange runtime partition pruning behaviour with 11.4  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Strange runtime partition pruning behaviour with 11.4  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: Strange runtime partition pruning behaviour with 11.4  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-performance
> 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






pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Strange runtime partition pruning behaviour with 11.4
Next
From: Andreas Kretschmer
Date:
Subject: Re: Strange runtime partition pruning behaviour with 11.4