Russell Smith <[EMAIL PROTECTED]> writes: > I would prefer an idle timeout if it's not costly. Because otherwise > estimates need to be made about how long VACUUM and backup could take, > and set the timeout longer.
Why? No one has suggested that the same timeout must be applied to every connection. Clients that are going to do maintenance stuff like VACUUM could just disable the timeout. This does bring up thoughts of whether the timeout needs to be a protected variable (SUSET or higher). I'd argue not, since a noncooperative client can certainly cause performance issues aplenty no matter what you try to impose with timeouts. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly