The following bug has been logged on the website:

Bug reference: 6423
Logged by: Weiyu Zhao
Email address: 139669962 (AT) qq (DOT) com
PostgreSQL version: 9.0.6
Operating system: Redhat 5.5 x86_64
Description:

The parameter max_standby_streaming_delay does not work. The parameter is
set 30s. My queries' duration is about 7 or 8 seconds. I still encounter
errors:
CSTFATAL: terminating connection due to conflict with recovery
CSTDETAIL: User query might have needed to see row versions that must be
removed.
CSTHINT: In a moment you should be able to reconnect to the database and
repeat your command.
I have a test case, but I don't know how to upload it.


--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On Tue, Jan 31, 2012 at 6:35 PM, <139669962 (AT) qq (DOT) com> wrote:
The following note in the document would help:

http://www.postgresql.org/docs/devel...TREAMING-DELAY
---------------
Note that max_standby_streaming_delay is not the same as the maximum
length of time a query can run before cancellation; rather it is the
maximum total time allowed to apply WAL data once it has been received
from the primary server. Thus, if one query has resulted in
significant delay, subsequent conflicting queries will have much less
grace time until the standby server has caught up again.
---------------

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs