Re: BUG #6571: Postgres Kills 'Select 1' query randomly on hot standby databases - Mailing list pgsql-bugs

Alex Matzinger <amatzinger@experts-exchange.com> writes:
> The connection that is executing the SELECT 1 are generally open for 1-5
> hours before they are killed.  The specific connection only executes
> SELECT 1.  The transaction is simply BEGIN, and then SELECT 1's, no
> other query is executed.

Lose the "BEGIN" and it will probably work more nicely.

            regards, tom lane