Does statement_timeout need to be set within a function?

Question

When I get a sudden spike in web users, some statements start queueing indefinitely, even though i'm setting a timeout like:

SET STATEMENT_TIMEOUT TO 5000; SELECT get_user_properties(12345);

Do functions ignore statement_timeout if it is not set within the function body?

I'm using postgresql 9.2 and pg_bouncer with session pooling.

Looks like setting it within the function doesn't work either. Is there a way to set statement_timeout per query? — Nick, Oct 02 '13 at 18:25

score 5 · Answer 1 · answered Oct 02 '13 at 18:52

5

This works

BEGIN; SET SESSION STATEMENT_TIMEOUT TO 5000; COMMIT; SELECT get_user_properties(12345);

answered Oct 02 '13 at 18:52

Nick

1 Answers1