Re: [PERFORM] Intersect/Union X AND/OR

2011-12-05 Thread Thiago Godoi
Filter: (id = 616)" "-> Subquery Scan on "*SELECT* 2" (cost=0.00..0.27 rows=1 width=0)" " -> Result (cost=0.00..0.26 rows=1 width=0)" The second plan is about 10 times faster than the first one. 2011/12/2 Merlin Moncure >

[PERFORM] Intersect/Union X AND/OR

2011-12-02 Thread Thiago Godoi
Hi all, I found this presentation from B. Momjian: http://momjian.us/main/writings/pgsql/performance.pdf I'm interested in what he said about " Intersect/Union X AND/OR " , Can I find a transcription or a video of this presentation? Can anyone explain it to me? Thanks, Thiago Godoi