Re: DBD::PG and long running queries and tcp stack timeout

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DBD::PG and long running queries and tcp stack timeout
Date: 2011-06-02 07:11:41
Message-ID: 4DE737AD.6030905@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/01/11 11:35 PM, Clemens Schwaighofer wrote:
> Hi,
>
> I have a script that runs a query on a remote server. The query will
> take quite some time to finish.
> Now the problem is that the tcp stack will timeout before the query is finished.

is there a NAT firewall or something else in the middle thats doing
connection tracking? tcp shouldn't time out like that even if your
query is taking multiple hours.

--
john r pierce N 37, W 123
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Schwaighofer 2011-06-02 07:56:17 Re: DBD::PG and long running queries and tcp stack timeout
Previous Message Clemens Schwaighofer 2011-06-02 07:02:38 DBD::PG and long running queries and tcp stack timeout