Re: [HACKERS] [GENERAL] Remove useless joins (VARCHAR vs TEXT)

2017-09-17 Thread Tom Lane
David Rowley writes: > On 17 September 2017 at 08:07, Kim Rose Carlsen wrote: >> It seems there are some difference in VARCHAR vs TEXT when postgres tries to >> decide if a LEFT JOIN is useful or not. > Yeah, it looks like the code to check for

Re: [HACKERS] [GENERAL] Remove useless joins (VARCHAR vs TEXT)

2017-09-16 Thread David Rowley
On 17 September 2017 at 08:07, Kim Rose Carlsen wrote: > It seems there are some difference in VARCHAR vs TEXT when postgres tries to > decide if a LEFT JOIN is useful or not. I can't figure out if this is > intentional because there are some difference between TEXT and VARCHAR