Buffers to Nest Loop Join and him pages - Mailing list pgsql-hackers

From Daniel Xavier de Sousa
Subject Buffers to Nest Loop Join and him pages
Date
Msg-id 20060623224831.52073.qmail@web52412.mail.yahoo.com
Whole thread Raw
List pgsql-hackers
<div class="MsoNormal"><span lang="EN-US" style="">Hi for all</span></div><div class="MsoNormal"><span lang="EN-US"
style="">Please,<br/> I have two doubts. Can somebody help me please??</span></div><div class="MsoNormal"><span
lang="EN-US"style=""> First doubt: I want know how many pages Postgres use when execute one query for Nest-loop-Join. I
haveused “explain analyze”, but it don’t give number of pages…</span></div><div class="MsoNormal"><span lang="EN-US"
style=""> Seconddoubt: Normally when some SGBD exec the algorithm Nest-Loop Join, there are differences about the space
ofmemory (buffer)  for  outer table  and  inner  table. So, I want know where (What file?) Postgres define the number
forthis spaces (buffers) ? And can I change it?<br style="" /></span></div><div class="MsoNormal"><span lang="EN-US"
style="">Ihave asked for others forum, but anybody has asked me. So Please, SOMEBODY HELP ME !!!</span></div> By<br />
Daniel<br/><p><hr size="1" /> Yahoo! doce lar. <a
href="http://us.rd.yahoo.com/mail/br/tagline/homepage_set/*http://br.yahoo.com/homepageset.html">Façado Yahoo! sua
homepage.</a>

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: vacuum, performance, and MVCC
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Out of memory error in 8.1.0 Win32