pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
insert and Update slow after implementing slony.
2+ messages / 2 participants
[nested] [flat]

* insert and Update slow after implementing slony.
@ 2008-12-17 04:03 Nimesh Satam <nimesh.zedo@gmail.com>
  2008-12-17 19:59 ` Re: insert and Update slow after implementing slony. David Rees <drees76@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Nimesh Satam @ 2008-12-17 04:03 UTC (permalink / raw)
  To: pgsql-performance@postgresql.org, nsatam@zedo.com, gauri@zedo.com, vidhya <vidhya@zedo.com>

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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: insert and Update slow after implementing slony.
  2008-12-17 04:03 insert and Update slow after implementing slony. Nimesh Satam <nimesh.zedo@gmail.com>
@ 2008-12-17 19:59 ` David Rees <drees76@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: David Rees @ 2008-12-17 19:59 UTC (permalink / raw)
  To: Nimesh Satam <nimesh.zedo@gmail.com>; +Cc: pgsql-performance@postgresql.org, nsatam@zedo.com, gauri@zedo.com, vidhya <vidhya@zedo.com>

On Tue, Dec 16, 2008 at 8:03 PM, Nimesh Satam <nimesh.zedo@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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-12-17 19:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-17 04:03 insert and Update slow after implementing slony. Nimesh Satam <nimesh.zedo@gmail.com>
2008-12-17 19:59 ` David Rees <drees76@gmail.com>

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