Re: [HACKERS] Buffer for inner and outer table

inner join (on RAM and HD). Do you know some thing about? Thanks Daniel Alvaro Herrera <[EMAIL PROTECTED]> 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_j

Re: [HACKERS] Buffer for inner and outer table

HD) when it execute Nest-loop-join?   Obrigado, Daniel Xavier de SousaMartijn van Oosterhout escreveu: On Sat, Jun 24, 2006 at 10:04:43PM +0300, Hannu Krosing wrote:> Maybe we could start from reusing the index tuples which point to> invisible tuples ? The index is no

[HACKERS] Buffers to Nest Loop Join and him pages

Hi for all Please, I have two doubts. Can somebody help me please??  First doubt: I want know how many pages Postgres use when execute one query for Nest-loop-Join. I have used “explain analyze”, but it don’t give number of pages…  Second doubt: Normally when some SGB