| From: | Chris Campbell <ccampbell(at)cascadeds(dot)com> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Time-Out Issue |
| Date: | 2014-01-08 19:38:20 |
| Message-ID: | 453A24085F801842AEA8D0B6B269065D03E0D8DDD33E@HDMC.cds.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
In PostgreSQL 9.3.2, is there a default time-out for running processes (specifically a view via a data connection) that take a long time? If so, how do I bump it up? My data connection (Devart) keeps returning time-out errors from PostgreSQL for views that must filter and return massive datasets. Smaller datasets it has no problem with.
The data connection I'm using has a timeout property but that deals only with how long it waits in trying to "establish" a connection to the database.
I'm thinking that there is a default time-out value in PostgreSQL that determines how long a process is allowed to run before it's considered a runaway process and is terminated by PostgreSQL.
Thanks,
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2014-01-08 19:43:42 | Re: Time-Out Issue |
| Previous Message | Sameer Kumar | 2014-01-08 08:04:55 | Re: Master-slave failover question |