Re: More Query Cancelled Matters

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