My server is a dual opteron 248
8GB DDR ECC
2 HD SCSI
Postgres 8.2.5
Linux: 2.6.17.13-SMP (optimized)
Slony 1.2.12 (compiled default)

Today is worst than yesterday ´cause is taking many time for any light
replication like simples insert and update, it now is taking around
4~5minutes on localnetwork.

Can i downgrade to 1.2.6? I did it on a test server and it worked even
with same errors messages like:

"Possible unsupported PostgreSQL version 8.2, defaulting to 8.0 support"

But even with this message the replication is working on test servers
and too much fast like 1.2.12.

Some advice?

Thanks



On Jan 16, 2008 2:52 PM, Michel <michelspintor at gmail.com> wrote:
> Hi,
>
> Sorry by my English, i´m from São Paulo - Brasil.
> I´ll try to explain my problem:
>
> I use slony on my company to replicate data from 1 master to 11 nodes.
> While i was using slony 1.2.6 everything was ok but after a upgrade
> for 1.2.12, everything is slower...
> Even on the localnetwork the time to replicate the data is to higher.
>
> Before what was taking fews seconds now in sometimes take minutes, on
> the same situations that before.
>
> The postmaster is with many process like this, what before was so fast
> that i coundn´t see::
>
> notify "_schema_Event"; notify "_schema_Confirm";
> select "_schema".forwardConfirm(3, 7, '1308481', '2008-01-16 15:47:48.718985');
> select "_schema".createEvent('_schema', 'SYNC', NULL);
>
> notify interrupt waiting
> notify interrupt waiting
>
> this process is doing: SELECT waiting
>
> Thanks
>