?
-
Phillip Couto
> On Jan 19, 2017, at 05:08, Clailson <clailson@gmail.com> wrote:
>
> Hi,
>
> Is there something in the roadmap to optimize the inner join?
>
> I've this situation above. Table b has 400 rows with null in the column b.
>
> explain ana
to recoup by ignoring them
before the merge sort.
I hope someone more familiar with the internals can chime in as I would like to
learn more if there is a real benefit here or a better idea why postgres does
not do it.
-
Phillip Couto
> On Jan 19, 2017, at 08:04, Clailson <cl
I apologize my statement about NULL being used to join is incorrect as both
Vitalii and Gustavo have both pointed out in their respective replies.
-
Phillip Couto
> On Jan 19, 2017, at 08:30, Vitalii Tymchyshyn <v...@tym.im> wrote:
>
>
> Hi.
>
> I
mind posting what versions of postgres you have tested
this on?
-
Phillip Couto
> On Jan 19, 2017, at 08:23, Gustavo Rezende Montesino
> <gustavo.montes...@trtsp.jus.br> wrote:
>
> Hello,
>
> Em 19/01/2017 11:04, Clailson escreveu:
>> Hi Phil
. Phillip CoutoFrom: ivo...@gmail.comSent: January 13, 2017 06:20To: stu...@stuartbishop.netCc: scott.marl...@gmail.com; pgsql