Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B4C1F632689 for ; Wed, 1 Apr 2009 11:23:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48631-05 for ; Wed, 1 Apr 2009 11:23:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by mail.postgresql.org (Postfix) with ESMTP id C832D6324E6 for ; Wed, 1 Apr 2009 11:23:48 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so27366ywj.73 for ; Wed, 01 Apr 2009 07:23:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=QcybUxKYOvHpTYegJVmspthFNc7fd+4n6HOI6+fjEm4=; b=cTjWWskHAUp64wzGKCYOwh+atw9boC3+ooxHjp/V5XlAR84A4AKavgLXdwqm2Ueolh aAf9jG1IJ4t2plym9y2QeoPQ107+w/5ihKsml1k+K8Tgbs6xZoA6Nab96udsz2DgI+am 7Knqtk1B9on++rTJqZlul9J0C+xYses0cN3Ws= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=V2aWSfDSPkJA8Lqw8HjvKzQx5Swc5tqtFT0e5AbPiVwaKwDbBeGLbL0rwVmt6FVza5 vHpOAhOsnX10g5OPzjXT3Iz6tJ2JA4TqxAvhAy3vtjGGsxf+J/v/krvPb2w4AqddfPaX IydYgdDMzz7pFzsakOHic9v/z3IQdaf9HLaOg= MIME-Version: 1.0 Received: by 10.100.33.15 with SMTP id g15mr6585442ang.48.1238595826582; Wed, 01 Apr 2009 07:23:46 -0700 (PDT) In-Reply-To: <49D32F83.7010402@vrancart.ro> References: <49D32F83.7010402@vrancart.ro> Date: Wed, 1 Apr 2009 10:23:46 -0400 Message-ID: <603c8f070904010723w1719d5fep7fcd30ed263529e7@mail.gmail.com> Subject: Re: PostgreSQL From: Robert Haas To: Mahu Vasile Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/6 X-Sequence-Number: 33373 On Wed, Apr 1, 2009 at 5:10 AM, Mahu Vasile wrote: > tcp_keepalives_count =3D 1 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0# TCP_KEEPCNT; This might not be what you want. http://www.postgresql.org/docs/8.3/static/runtime-config-connection.html Presumably you'd like to wait more than 1 second before declaring the connection dead... Beyond, that it sounds like a client problem more than a PostgreSQL problem= . ...Robert