On Fri, 4 Nov 2005, Tony Caduto wrote:
> > hmm, I waited for at least 1 minute after doing the reload and it was > never updated. It seemed at the time that the only way to get a updated > pg_settings view was to actually restart the server. I plan on doing > some more testing on Saturday. > Did you set "constraint_exclusion = on", then comment it "#constraint_exclusion = on" in the .conf file? If so, then ProcessConfigFile() will ignore this line since it is a comment, instead of setting back its value to "off". Try to do set "constraint_exclusion = off" explicitely, see if long delay ever happens. Btw, is this considered a bug of ProcessConfigFile()? To fix it, we can call InitializeGUCOptions() somewhere but I am not sure which values should be untouched, like ConfigFileName ... Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org