Re: merge semi join cost calculation error

2018-10-08 Thread Pavel Stehule
po 8. 10. 2018 v 17:00 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > The user sent a plan: > > > QUERY PLAN > > Merge Semi Join (cost=82.97..580.24 rows=580 width=8) (actual > > time=0.503..9557.396 rows=721 loops=1) > > Merge Cond: (tips.users_id = follows.users_id_to) > > -> In

Re: merge semi join cost calculation error

2018-10-08 Thread Tom Lane
Pavel Stehule writes: > The user sent a plan: > QUERY PLAN > Merge Semi Join (cost=82.97..580.24 rows=580 width=8) (actual > time=0.503..9557.396 rows=721 loops=1) > Merge Cond: (tips.users_id = follows.users_id_to) > -> Index Scan using tips_idx_users_id01 on tips (cost=0.43..8378397.19 >

merge semi join cost calculation error

2018-10-08 Thread Pavel Stehule
Hi I try to understand to a issue https://stackoverflow.com/questions/52685384/subquery-performance-on-simple-case The user sent a plan: QUERY PLAN Merge Semi Join (cost=82.97..580.24 rows=580 width=8) (actual time=0.503..9557.396 rows=721 loops=1) Merge Cond: (tips.users_id = follows.users_i