X-Original-To: pgsql-admin-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id CC9BB9FB1B7
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 23 Jun 2006 15:39:24 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 95030-03 for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 23 Jun 2006 15:39:17 -0300 (ADT)
X-Greylist: delayed 00:06:37.340821 by SQLgrey-
Received: from web52407.mail.yahoo.com (web52407.mail.yahoo.com
	[206.190.48.170])
	by postgresql.org (Postfix) with SMTP id DAA599FA64B
	for <pgsql-admin@postgresql.org>; Fri, 23 Jun 2006 15:39:17 -0300 (ADT)
Received: (qmail 49410 invoked by uid 60001); 23 Jun 2006 18:32:35 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=x3x6t4nUj8Lcj2NjtG1nW/vup9Z5s4WoO2JA6X/5eOKojsB86fs6SlRIasHSDnRp9qYwOMXVlWfQdg3VTf01PnjBDu1+VSC6UIUzHC4XddKmMbqsvE1DYPf+skkx7gbgi9M5rWm30DArbF+ry5Wxx8rPDcPxXXQzkq4oYse3mXU=
	;
Message-ID: <20060623183235.49408.qmail@web52407.mail.yahoo.com>
Received: from [201.79.100.24] by web52407.mail.yahoo.com via HTTP;
	Fri, 23 Jun 2006 15:32:35 ART
Date: Fri, 23 Jun 2006 15:32:35 -0300 (ART)
From: Daniel Xavier de Sousa <danielucg@yahoo.com.br>
Subject: Buffers to Nest Loop Join
To: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1427742670-1151087555=:48936"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/215
X-Sequence-Number: 22177

--0-1427742670-1151087555=:48936
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi for all,
  
  Please,
  Normaly when some SGBD exec the algoritm Nest-Loop Join, there are  diferences about the space(buffer)  for  outer table   and  inner  table. So, I want know where Postgres define the  number for this spaces (buffers)? And can I change it?
  
  This is very important to me.
  
  Thanks, 
  I hope that somebody can help me.
  By
  Daniel
  
  
 		
---------------------------------
 Abra sua conta no Yahoo! Mail - 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz. 
--0-1427742670-1151087555=:48936
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi for all,<br>  <br>  Please,<br>  Normaly when some SGBD exec the algoritm Nest-Loop Join, there are  diferences about the space(buffer)&nbsp; for&nbsp; outer table&nbsp;  and&nbsp; inner&nbsp; table. So, I want know where Postgres define the  number for this spaces (buffers)? And can I change it?<br>  <br>  This is very important to me.<br>  <br>  Thanks, <br>  I hope that somebody can help me.<br>  By<br>  Daniel<br>  <br>  <p>&#32;
		<hr size=1> 
<a href="http://us.rd.yahoo.com/mail/br/tagline/mail/*http://mail.yahoo.com.br/">Abra sua conta no Yahoo! Mail</a> - 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz. 
--0-1427742670-1151087555=:48936--