Re: Streaming replication on 9.1-beta2 after pg_restore is very slow

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: David Hartveld <david(dot)hartveld(at)mendix(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow
Date: 2011-07-07 14:45:06
Message-ID: CA+U5nMKMLRL9Pcy9Eg9NyBnGOUVeKLdwYvhQMO5oEECRj+V08Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 7, 2011 at 3:37 PM, David Hartveld
<david(dot)hartveld(at)mendix(dot)com> wrote:

> Other suggestions?

If speed is your concern, a little performance tuning might help,
judging from your configs.
http://www.2ndQuadrant.com/books/ or other sources will help.

I'm interested in seeing some ERROR messages from either system,
showing their sequence between master/standby. At the moment its not
clear what the first error is. Subsequent messages are less
interesting.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-07-07 15:14:05 Re: Streaming replication on 9.1-beta2 after pg_restore is very slow
Previous Message Jeff Davis 2011-07-07 14:35:17 Re: Latency problems with simple queries