Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B681B6500AC for ; Wed, 17 Dec 2008 00:03:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80226-04-7 for ; Wed, 17 Dec 2008 00:03:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.171]) by mail.postgresql.org (Postfix) with ESMTP id 55CD465016E for ; Wed, 17 Dec 2008 00:03:22 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 25so3270736wfc.28 for ; Tue, 16 Dec 2008 20:03:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=GsKnBWPoR5DbmXqoI83XyAPMJruxUvTZpVOefXc0XlU=; b=VgXWuEpUhjKx8NG5dHtfaZ0o+0906OgGVqxduw8oQgj3knxMX88i5ynPQ8dga+oLcE FNj6B+kv1ypPoYo8jpKB/oQJQsFWH+olllVU3wC3lPq25KC/wwUevHijCfkfdV2NQWfc 4XdOB9jKGo3HHacF4c67UrDIj7EWA+4uUjyRQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=G4a4LBFAz3Bv09qrlcpMhkd9Xr5CY03IAFlJqY45Cne0NNnopRv7vliGfRiRfmkG2J kuDQTbH5zVsb6iSziPLo2ncAd1uXuh3Fqopnfedbzw3cLlt5rXXf8SluiFddM6xCNYnk zdYStLde0i3wZEb+Bx7NHB7RNEu8OPk+E9Qbo= Received: by 10.142.90.13 with SMTP id n13mr110264wfb.167.1229486601315; Tue, 16 Dec 2008 20:03:21 -0800 (PST) Received: by 10.142.178.21 with HTTP; Tue, 16 Dec 2008 20:03:21 -0800 (PST) Message-ID: <965aa3ed0812162003w43bb3ad4la18898506c1f9ef@mail.gmail.com> Date: Wed, 17 Dec 2008 09:33:21 +0530 From: "Nimesh Satam" To: pgsql-performance@postgresql.org, nsatam@zedo.com, gauri@zedo.com, vidhya Subject: insert and Update slow after implementing slony. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10594_9736648.1229486601311" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200812/158 X-Sequence-Number: 32194 ------=_Part_10594_9736648.1229486601311 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, We are trying to implement slony as a replication tool for one of our database. The Insert and updates have increased by approximately double making some of our important script slow. The database in concern is a warehouse and we have added additional primary key to support slony by using default vale as SERIAL for the primary key. Can you any one let us know what we can do to speed up the queries and if it is a good idea to use Slony for db warehouse? Let me know if you need any further informatiom. Regards, Nimesh. ------=_Part_10594_9736648.1229486601311 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi,
 
We are trying to implement slony as a replication tool for one of our database. The Insert and updates have increased by approximately double making some of our important script slow.
 
The database in concern is a warehouse and we have added additional primary key to support slony by using default vale as SERIAL for the primary key.
 
Can you any one let us know what we can do to speed up the queries and if it is a good idea to use Slony for db warehouse?
 
Let me know if you need any further informatiom.
 
Regards,
Nimesh.
------=_Part_10594_9736648.1229486601311--