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