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: | Raw Message | Whole Thread | 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 |