Mark wrote:
> Is it normal to have rollbacks going pretty often?
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591365-2]
> "_status_reportscluster".sl_action_seq;
> Jun 20 11:18:01 sourceforge postgres[22294]: [4019490] LOG:  query:
> rollback transaction;
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591366] LOG:  duration:
> 0.000318 sec
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591367] LOG:  query:
> rollback transaction;
> Jun 20 11:18:01 sourceforge postgres[22294]: [4019491] LOG:  duration:
> 0.000222 sec
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591368] LOG:  duration:
> 0.000209 sec
>
>
Absolutely.  There's a ROLLBACK for the read transaction each and every
SYNC that gets processed.