pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Aldor <an@mediaroot.de>
To: pgsql-admin@postgresql.org
Subject: Slony1-1.1.0: Triggers are making other things slower?
Date: Sat, 24 Sep 2005 12:47:25 +0100
Message-ID: <43353CCD.9070703@mediaroot.de> (raw)

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



Message-ID: <43353CCD.9070703@mediaroot.de>
Permalink:  ../43353CCD.9070703@mediaroot.de/
Also on:    postgresql.org/message-id/43353CCD.9070703@mediaroot.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: an@mediaroot.de
  Subject: Re: Slony1-1.1.0: Triggers are making other things slower?
  In-Reply-To: <43353CCD.9070703@mediaroot.de>
  References: <43353CCD.9070703@mediaroot.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox