Re: [HACKERS] Buffer for inner and outer table

[Daniel Xavier de Sousa]

Hi Álvaro,
 
Thank you about your answer.

I thought that Postgres could management the space for outer and inner tables. Because, some articles has showed how this make the difference.

 Alvaro please,

And about count of pages that postgres read on query inner join (on RAM and HD). Do you know some thing about?

Thanks

Daniel

Alvaro Herrera <[EMAIL PROTECTED]> escreveu:

Daniel Xavier de Sousa wrote:

> Somebody can tell me, where the postgres control the buffer for
> inner and outer table, when it execute Nest_loop_join? I would want
> how to change the size this buffer and see all statistics about
> this

There is no such buffer. Buffers used in scans are kept in
shared_buffers, just like for everything else.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---

Yahoo! Copa 2006 - cobertura dos jogos em tempo real e tudo sobre a seleção brasileira!