| From: | Clemens Schwaighofer <clemens(dot)schwaighofer(at)e-graphics(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | DBD::PG and long running queries and tcp stack timeout |
| Date: | 2011-06-02 06:35:55 |
| Message-ID: | BANLkTi=RFaK+EQ1c_Mwo9bwW6+SsCogvxA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
I am running the query as async and have a loop where I query the
pg_ready status every 5 seconds.
Is there anyway to send some NOOP or anything so this connection does
not timeout? Just reading pg_ready seems to do nothing, probably
because it gets filled once the query is done.
Running the query as not async has the same issues with timeout.
--
★ Clemens 呉 Schwaighofer
★ IT Engineer/Web Producer/Planning
★ E-Graphics Communications SP Digital
★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN
★ Tel: +81-(0)3-3545-7706
★ Fax: +81-(0)3-3545-7343
★ http://www.e-gra.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clemens Schwaighofer | 2011-06-02 07:02:38 | DBD::PG and long running queries and tcp stack timeout |
| Previous Message | Craig Ringer | 2011-06-02 02:32:12 | Re: SELECT to_timestamp crash PostgreSQL 9.1beta1 |