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

From: David Hartveld
Subject: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow
Date: ,
Msg-id: 0317654684C3CF48B06D8FF5AE5D2EE0D257@Win-Exchange-02.MENDIXDOMAIN.local
(view: Whole thread, Raw)
In response to: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow  (Simon Riggs)
Responses: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow  (Simon Riggs)
List: pgsql-general


> -----Oorspronkelijk bericht-----
> Van: Simon Riggs [mailto:]
> Verzonden: donderdag 7 juli 2011 01:07
> Aan: David Hartveld
> CC: 
> Onderwerp: Re: [GENERAL] Streaming replication on 9.1-beta2 after pg_restore
> is very slow
>
> On Wed, Jul 6, 2011 at 4:54 PM, David Hartveld <>
> wrote:
>
> > Is there possibly a known issue with the beta, or do I have to
> > configure my cluster differently for 9.1?
>
> Thanks for trying 9.1beta
>
> No known bugs, no differences in configuration.
>
> You haven't enabled any of the new 9.1 features either so they aren't likely to be
> at issue.
>
> So there's something pretty badly screwed up somewhere, though that looks like
> pilot error at the moment, sorry.
>
> I'd suggest starting again and see if you can get a reproduceable bug.
> I'd be very grateful if you can narrow things down to produce a tight bug report.

I've just submitted bug report 6094, with a complete description of what I have done. The replication stream is
reproduciblyvery slow. If you need more information, let me know. 


pgsql-general by date:

From: mike beeper
Date:
Subject: Creating temp tables inside read only transactions
From: Alan Hodgson
Date:
Subject: Re: Add Foreign Keys To Table