Sv: Re: inner join elimination

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Sv: Re: inner join elimination
Date: 2018-06-07 22:03:50
Message-ID: VisenaEmail.2c.cc9d721decb1c23c.163dc468f55@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

På torsdag 07. juni 2018 kl. 23:44:04, skrev pinker <pinker(at)onet(dot)eu
<mailto:pinker(at)onet(dot)eu>>:
As far as I know PostgreSQL does only OUTER JOIN Elimination, with inner join
it doesn't work.
 
See this thread:

https://www.postgresql.org/message-id/flat/VisenaEmail(dot)2b(dot)7dfa64bdab147c49(dot)1600d1d9df0%40tc7-visena#VisenaEmail(dot)2b(dot)7dfa64bdab147c49(dot)1600d1d9df0(at)tc7-visena
 
-- Andreas Joseph Krogh

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ahmed, Nawaz 2018-06-07 22:10:02 RE: Service pgpool
Previous Message Robert Creager 2018-06-07 22:02:31 Re: Query hitting empty tables taking 48 minutes