Re: [PERFORM] Optimization inner join

2017-01-19 Thread Phillip Couto
? - 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

Re: [PERFORM] Optimization inner join

2017-01-19 Thread Phillip Couto
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

Re: [PERFORM] Optimization inner join

2017-01-19 Thread Phillip Couto
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

Re: [PERFORM] Optimization inner join

2017-01-19 Thread Phillip Couto
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

Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-13 Thread Phillip Couto
. Phillip CoutoFrom: ivo...@gmail.comSent: January 13, 2017 06:20To: stu...@stuartbishop.netCc: scott.marl...@gmail.com; pgsql