Hi Jeff,
Thanks for the update and clarification. I will look to see a better
alternative to resolve this twice execution of same plan.
On Wed, Sep 20, 2017 at 10:16 PM, Jeff Janes wrote:
> On Tue, Sep 19, 2017 at 7:31 PM, monika yadav
> wrote:
>
>> Hi All,
>>
>> I didn't understand why same s
On Tue, Sep 19, 2017 at 7:31 PM, monika yadav
wrote:
> Hi All,
>
> I didn't understand why same sub plan for the sub query executed two
> times? As per the query it should have been executed only once.
>
> Can someone please explain this behaviour of query execution ?
>
The sum_bid at the end o
Hi All,
I didn't understand why same sub plan for the sub query executed two times?
As per the query it should have been executed only once.
Can someone please explain this behaviour of query execution ?
Thanks a lot.
On Wed, 20 Sep 2017 at 5:01 AM, Jeff Janes wrote:
> I have a complicated qu
I have a complicated query which runs the exact same subplan more than once.
Here is a greatly simplified (and rather pointless) query to replicate the
issue:
select aid, sum_bid from
(select
aid,
(select sum(bid) from pgbench_branches
where bbalance between -1
