Time-Out Issue

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

Responses

Browse pgsql-novice by date

  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