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

Re: [PERFORM] Optimization inner join

2017-01-19 Thread Phillip Couto
? - Phillip Couto > On Jan 19, 2017, at 05:08, Clailson 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 analyze select * from a inner join

Re: [PERFORM] Optimization inner join

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

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 wrote: > > > Hi. > > In SQL "null ==

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 > wrote: > > Hello, > > Em 19/01/2017 11:04, Clailson escreveu: >> Hi Phillip. >> >> >>> &