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