Re: Plan not skipping unnecessary inner join

From: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: hippysoyboy(at)gmail(dot)com, postgres(at)binarykeep(dot)com
Subject: Re: Plan not skipping unnecessary inner join
Date: 2020-05-17 12:32:47
Message-ID: CAEudQAo8HdPhqdg85BPn4qRsyY2Ep4PY7nNKJ29ZtzZqueAkKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I redid the same tests with vanila postgres and with empty tables.
I'm surprised, why does the plan have 2550 rows in explain?

regards,
Ranier Vilela

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2020-05-17 13:31:24 Re: Plan not skipping unnecessary inner join
Previous Message Matthew Nelson 2020-05-15 17:36:58 Re: Plan not skipping unnecessary inner join