Sv: Re: inner join elimination

2018-06-07 Thread Andreas Joseph Krogh
På torsdag 07. juni 2018 kl. 23:44:04, skrev pinker mailto:pin...@onet.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.2b.7dfa64bdab147c49.1600d1d9df0%40tc7-visena#Visena

Re: inner join elimination

2018-06-07 Thread pinker
As far as I know PostgreSQL does only OUTER JOIN Elimination, with inner join it doesn't work. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

inner join elimination

2018-05-29 Thread Arturo Guadagnin
Hi I was just wondering whether inner join elimination is working in postgres, so I put up a simple test case and compared it with an Oracle database (see output below). It doesn't look like this feature is implemented in postgres, or am I missig something? Are there any plans to impleme