Skip to main content
Question

PostgreSQL Query - Never Times Out

  • March 19, 2018
  • 2 replies
  • 48 views
jbradfor
Contributor
Forum|alt.badge.img+7

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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • March 20, 2018

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;
jbradfor
Contributor
Forum|alt.badge.img+7
  • jbradforContributor
  • Author
  • Contributor
  • May 3, 2018

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...

 

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.