Re: Possible problem with pg_reload_conf() and view pg_settings

Qingqing Zhou wrote:

>
>test=# LOG:  received SIGHUP, reloading configuration files
>
>test=# select setting from pg_settings where name = 'constraint_exclusion';
> setting
>---------
> off
>(1 row)
>
>test=# select setting from pg_settings where name = 'constraint_exclusion';
> setting
>---------
> on
>(1 row)
>
>
>-- Seems that's due to delay of process SIGHUP ...
>
>
>  
>

What's the delay? 1s? 5? 10?

cheers

andrew