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