Horton

Re: convert EXSITS to inner join gotcha and bug

David Rowley <david.rowley@2ndquadrant.com>

View thread View on postgr.es
From: David Rowley <david.rowley@2ndquadrant.com>
To: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: Teodor Sigaev <teodor@sigaev.ru>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2017-04-28T15:56:34Z
Lists: pgsql-hackers 
On 29 April 2017 at 00:45, Alexander Korotkov <a.korotkov@postgrespro.ru> wrote:
> On default config, after loading example.sql.bz2 and VACUUM ANALYZE, query
> result is OK.

Hi,

Did you mean to attach this?

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Commits

  1. Reduce semijoins with unique inner relations to plain inner joins.

  2. Fix mis-optimization of semijoins with more than one LHS relation.