RE: Terminate the idle sessions - Mailing list pgsql-hackers

Dear Li,

> Thanks for your advice! Attached v4.

I confirmed it. OK.

> @@ -30,6 +30,7 @@ typedef enum TimeoutId
>      STANDBY_DEADLOCK_TIMEOUT,
>      STANDBY_TIMEOUT,
>      STANDBY_LOCK_TIMEOUT,
> +    IDLE_SESSION_TIMEOUT,
>      IDLE_IN_TRANSACTION_SESSION_TIMEOUT,
>      /* First user-definable timeout reason */
>      USER_TIMEOUT,

I'm not familiar with timeout, but I can see that the priority of idle-session is set lower than transaction-timeout.
Could you explain the reason? In my image this timeout locates at the lowest layer, so it might have the lowest 
priority.

Other codes are still checked :-(.

Hayato Kuroda
FUJITSU LIMITED