Praveen Kumar N <praveen_n@students.iiit.net> 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