Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > As I understand it, the postmaster shared memory idea is good because > > only the postmaster writes to it, and only the backends read from it. > > If the HANDLE works the same way, I think you should put it into the > > shared memory too, hence (b). > > But the postmaster needs to use the HANDLE, hence not (b).
That's where I was unclear. If the postmaster has to read the HANDLE, we are better with keeping it in local memory (a). -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
