Praveen Kumar N <[EMAIL PROTECTED]> writes:

> hai...
>
>         I have installed postgresql from sourcecode.I would like to know
> how pages are replaced in the bufferpool when we join two relations.I tried to
> trace it by editing files
> pgsql/src/backend/storage/buffer/(bufmgr.c,freelist.c).But i feel still I
> am missing some information after observing extracted information abt buffer
> replacement.

Try

explain select ...

The output may be enlightening.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to