Skip to main content
  • EN

We use a PostgreSQL connection to access our GreenPlum
environment to execute a SQL statement to pull non-spatial point data. Normal Query runtime, runs fine.

When the tables involved in the SQL are under heavy load,
the query slows down a lot. It then
NEVER returns anything and will continue to run until we stop it.

So, my question is.
When we setup connections in FME desktop, is there any way to setup a
MAX connection timeout or Query timeout?

Hi @jbradfor, if you're able to use an SQLCreator or SQLExecutor, you might be able to set the timeout there 

set statement_timeout to 100;

Hi @jbradfor, if you're able to use an SQLCreator or SQLExecutor, you might be able to set the timeout there 

set statement_timeout to 100;
I was able to get this to work.  Thanks.

 

 

FME_SQL_DELIMITER ;
set statement_timeout to 1800000;  --30 min
select distinct...

 

Reply


Community Stats

30,108
Posts
114,293
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.