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