David Rickard <David.Rickard@GTScompanies.com> writes:
> We're still encountering situations (vacuum, exports, certain queries &
> psql commands) where PostGreSQL throws a "psql: ERROR: Query was
> cancelled." message;
> Previous enquiries on this issue have received suggestions that something
> on our server may be throwing SIGINTs--but our system people cannot find
> anything that might be causing such events;
> We are attaching our postgresql.conf file, on the off chance that someone
> can see some mis-set value(s) therein;
Like this one?
> statement_timeout = 120 # 0 is disabled, in milliseconds
This will trigger "Query was canceled" for any query running longer than
120 msec, which is not a lot ...
regards, tom lane