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 i
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
Hi,Please, 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 another doubt, how can I see the pages access (on Ram and HD