On Tue, Dec 16, 2008 at 8:03 PM, Nimesh Satam <nimesh.z...@gmail.com> wrote: > 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.
What version of PostgreSQL are you running and on what type of hardware? I suspect that moving pg_log onto a separate spindle and/or upgrading your RAID controller to something with a BBU and configured in write-back mode would get most of your performance back. If you aren't running PostgreSQL 8.3, that might also help update performance significantly as well. -Dave -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
