Buffers to Nest Loop Join

From: Daniel Xavier de Sousa <danielucg(at)yahoo(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Buffers to Nest Loop Join
Date: 2006-06-23 18:32:35
Message-ID: 20060623183235.49408.qmail@web52407.mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2006-06-23 22:31:54 Re: strange fsm issues
Previous Message Tom Lane 2006-06-23 17:18:18 Re: Out of memory error

Browse pgsql-performance by date

  From Date Subject
Next Message Franklin Haut 2006-06-23 21:58:22 Temporary table
Previous Message Tom Lane 2006-06-23 16:09:41 Re: Occupation bloc in pages of table