Thank you :) On Sat, 2006-04-22 at 18:16 -0400, Tom Lane wrote: > Gevik Babakhani <[EMAIL PROTECTED]> writes: > > Could someone please explain the MemoryContext switching. For example > > MemoryContextSwitchTo function. How does this work? > > src/backend/utils/mmgr/README might help. It's somewhat pointed at > people who've already been hacking the backend, but I think it will > give you the idea. > > The basic point is that palloc() allocates memory in whichever context > was last selected as CurrentMemoryContext by MemoryContextSwitchTo. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly >
---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match