Bruce Momjian <[EMAIL PROTECTED]> writes:
> Stephan Szabo wrote:
>> It looks like deadlock_timeout is set PGC_POSTMASTER so it's not
>> supposed to be reread on SIGHUP (reload) but only on postmaster start.
> I think it doesn't reload because we want to have the same timeouts for
> all backends, and reload doesn't happen at the same instant for all
> backend.
Yeah, I've forgotten the details, but I'm pretty sure we were worried
about race conditions or missed timeouts of some sort if we allowed
deadlock_timeout to change on-the-fly. Try digging in the archives
if you want the whole scoop.
regards, tom lane
---------------------------(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
