Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins

2016-02-08 Thread Hedayat Vatankhah
Hi again, /*Hedayat Vatankhah*/ wrote on Sun, 31 Jan 2016 01:20:53 +0330: Hi, /*David Rowley*/ wrote on Sun, 31 Jan 2016 04:57:04 +1300: On 31 January 2016 at 01:30, Hedayat Vatankhah <hedayat@gmail.com> wrote: Personally, I expect both queries below to perform exactly the same:

Re: [PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins

2016-01-30 Thread Hedayat Vatankhah
Hi, /*David Rowley*/ wrote on Sun, 31 Jan 2016 04:57:04 +1300: On 31 January 2016 at 01:30, Hedayat Vatankhah <hedayat@gmail.com> wrote: Personally, I expect both queries below to perform exactly the same: SELECT t1.id, * FROM t1 INNER JOIN t2 ON t1.id = t2.id wh

[PERFORM] PostgreSQL seems to create inefficient plans in simple conditional joins

2016-01-30 Thread Hedayat Vatankhah
Dear all, First of all, I should apologize if my email doesn't follow all the guidelines. I'm trying to do that though! If referencing to links is OK, you can find the full description of the issue at: