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