Horton

Re: Problem with reading data from standby server ?

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: pgsql-general@postgresql.org
Cc: Condor <condor@stz-bg.com>
Date: 2012-04-21T09:59:07Z
Lists: pgsql-general 
On Friday, April 20, 2012 10:39:25 AM Condor wrote:
> array_accumulate aggregate is:
> 
> 
> CREATE AGGREGATE array_accumulate (
>      sfunc = array_append,
>      basetype = anyelement,
>      stype = anyarray,
>      initcond = '{}'
> );
Btw, if you replace that by array_agg which is builtin in any version support 
HS/SR the whole query might finish faster and thus is less likely to cause 
conflicts.

If youre already on 9.1 you might also want to look into hot_standby_feedback 
that can also reduce the likelihood of conflicts by informing the master what 
is going on on the standby.

Greetings,

Andres