Re: Problem with reading data from standby server ?

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