On 08/30/11 18:03, Fujii Masao wrote:
On Wed, Aug 31, 2011 at 5:51 AM, Jeff Rossjr...@wykids.org wrote:
Is there a setting in this or something else that I should tweak so this
query can complete against the replica? Google turned up some threads on
the error code associated with the error
Hi,
I have a set of servers in the rack running 9.0.3. The production
server is doing streaming replication and that is working fine. I have
some quarterly reports that are select only so I've been running them
against the replica.
I have one part of that report that consistently dies
On Wed, Aug 31, 2011 at 5:51 AM, Jeff Ross jr...@wykids.org wrote:
Is there a setting in this or something else that I should tweak so this
query can complete against the replica? Google turned up some threads on
the error code associated with the error but I didn't find much else that
seems
On 31/08/2011 4:51 AM, Jeff Ross wrote:
On my workstation using psql this query runs in about 1.5 minutes. I can
choose the quarter the query uses and I'm virtually positive that no
rows in that set will be updated or deleted so the error message to me
seems wrong.
AFAIK: There may be other