X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5F6F3D8D30 for ; Sat, 24 Sep 2005 08:47:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03620-02 for ; Sat, 24 Sep 2005 11:47:16 +0000 (GMT) Received: from 217-20-115-93.internetserviceteam.com (217-20-115-93.internetserviceteam.com [217.20.115.93]) by svr1.postgresql.org (Postfix) with ESMTP id BEFF8D6EB0 for ; Sat, 24 Sep 2005 08:47:17 -0300 (ADT) Received: from [192.168.1.48] (103.Red-81-44-2.dynamicIP.rima-tde.net [81.44.2.103]) by 217-20-115-93.internetserviceteam.com (Postfix) with ESMTP id D6A5639BF3 for ; Sat, 24 Sep 2005 13:03:23 +0200 (CEST) Message-ID: <43353CCD.9070703@mediaroot.de> Date: Sat, 24 Sep 2005 12:47:25 +0100 From: Aldor User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Slony1-1.1.0: Triggers are making other things slower? Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 required=5 tests=[AWL=0.013] X-Spam-Level: X-Archive-Number: 200509/282 X-Sequence-Number: 19019 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