Re: Buffer for inner and outer table - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Buffer for inner and outer table
Date
Msg-id 20060624220545.GB5316@alvh.no-ip.org
Whole thread Raw
In response to Re: Buffer for inner and outer table  (Daniel Xavier de Sousa <danielucg@yahoo.com.br>)
Responses Re: Buffer for inner and outer table  (Daniel Xavier de Sousa <danielucg@yahoo.com.br>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Daniel Xavier de Sousa
Date:
Subject: Re: Buffer for inner and outer table
Next
From: Christopher Browne
Date:
Subject: Re: vacuum, performance, and MVCC