Re: Problem with reading data from standby server ?

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Cc: Condor <condor(at)stz-bg(dot)com>
Subject: Re: Problem with reading data from standby server ?
Date: 2012-04-21 09:59:07
Message-ID: 201204211159.07501.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message F. BROUARD / SQLpro 2012-04-21 14:17:12 Starnge things with big datas...
Previous Message John R Pierce 2012-04-21 08:29:01 yum repo issue