<div class="MsoNormal">Hi Álvaro,<br /> <br /><span lang="EN-US" style="">Thank you about your
answer.</span></div><divclass="MsoNormal"><span lang="EN-US" style="">I thought that Postgres could management the
spacefor outer and inner tables. Because, some articles has showed how this make the difference.<br /></span></div><div
class="MsoNormal"><spanlang="EN-US" style=""> Alvaro please,</span></div><div class="MsoNormal"><span lang="EN-US"
style="">Andabout count of pages that postgres read on query inner join (on RAM and HD). Do you know some thing about?
<br/></span></div><div class="MsoNormal"><span lang="EN-US" style="">Thanks </span></div><div class="MsoNormal"><span
lang="EN-US"style="">Daniel </span></div><br /><br /><b><i>Alvaro Herrera <alvherre@commandprompt.com></i></b>
escreveu:<blockquoteclass="replbq" style="border-left: 2pxsolid rgb(16, 16, 255); margin-left: 5px; padding-left:
5px;">Daniel Xavier de Sousa wrote:<br /><br />> Somebody can tell me, where the postgres control the buffer for<br
/>>inner and outer table, when it execute Nest_loop_join? I would want<br />> how to change the size this buffer
andsee all statistics about<br />> this<br /><br />There is no such buffer. Buffers used in scans are kept in<br
/>shared_buffers,just like for everything else.<br /><br />-- <br />Alvaro Herrera http://www.CommandPrompt.com/<br
/>PostgreSQLReplication, Consulting, Custom Development, 24x7 support<br /></blockquote><br /><p><hr size="1" /><a
href="http://us.rd.yahoo.com/mail/br/tagline/copa/*http://br.esportes.yahoo.com/copa2006/">Yahoo!Copa 2006</a> -
coberturados jogos em tempo real e tudo sobre a seleção brasileira!
