Skip site navigation (1) Skip section navigation (2)

Slony1-1.1.0: Triggers are making other things slower?

From: Aldor <an(at)mediaroot(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Slony1-1.1.0: Triggers are making other things slower?
Date: 2005-09-24 11:47:25
Message-ID: 43353CCD.9070703@mediaroot.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

I don't really know how Slony works internally but I know that it uses
some triggers for getting out new transactions.

The config of my Slony cluster:

--- CONFIG START ---

cluster name = $CLUSTERNAME;

node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
port=$MASTERPORT user=$REPLICATIONUSER password=$MASTERPASS';
node 2 admin conninfo = 'dbname=$SLAVE1DBNAME host=$SLAVE1HOST
port=$SLAVE1PORT user=$REPLICATIONUSER password=$SLAVE1PASS';

init cluster ( id=1, comment = $CLUSTERNAME);

create set (id=1, origin=1, comment=$CLUSTERTABLE1);
set add table (set id=1, origin=1, id=1, fully qualified name =
'public.[table]', comment=$CLUSTERTABLE1);

--- CONFIG END ---

Of course I have also other tables in the same database, which I don't
want to cluster. When making big data dumps into that tables I noticed
that since I'm using Slony on that database, buf for another table, the
big dumps are getting 5-10 times slower. The only explanation I have is
that it has maybe something to do with Slony - because nothing else have
been changed. May be Slony do in each row dump of the process any things
which can slow down the process - even if Slony should not care about
this other table?!

Thanks,

Aldor

pgsql-admin by date

Next:From: Robert NgoDate: 2005-09-24 14:25:53
Subject: postgresql on SAN
Previous:From: AldorDate: 2005-09-24 11:40:57
Subject: Slony1-1.1.0: UNSUBSCRIBE SET and SUBSCRIBE SET

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group