Joe Sunday <[EMAIL PROTECTED]> writes: > On Tue, Mar 14, 2006 at 11:29:57PM -0500, Tom Lane wrote: >> What I'd try is first letting the problem case run for a bit, then >> stopping it with gdb and dumping out a few Kb of the frontmost memory >> block in the ExecutorState context. Sometimes, looking at the data
> Can you point me a little more in that direction? I can't figure out how > to get a handle to that context. Well, it's nearly hopeless with a non-debug build, which is what you seem to have there :-(. With debug symbols, printing the parameter passed to AllocSetAlloc is easy enough. regards, tom lane ---------------------------(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