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 <alvherre@commandprompt.com> 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!
