Greg Williamson <[email protected]> writes:
> Every minute on the minute there is a cronjob that kills IDLE IN CONNECTION
> procs older than 3 seconds ... possibly that process killed the process I was
> running, but to me the user it seemed as if the COMMIT came before the
> disconnect.
That sure sounds like the source of your problem. It might be sane if
it killed only processes that *had been idle* for at least three
seconds, but I'm not sure there is any easy way to determine that ...
regards, tom lane
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
