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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org