Re: Streaming replication on 9.1-beta2 after pg_restore is very slow - Mailing list pgsql-general

From David Hartveld
Subject Re: Streaming replication on 9.1-beta2 after pg_restore is very slow
Date
Msg-id 4E16DB3E.302@mendix.com
Whole thread Raw
In response to Re: Streaming replication on 9.1-beta2 after pg_restore is very slow  (David Hartveld <david.hartveld@mendix.com>)
List pgsql-general
Op 08-07-11 10:19, David Hartveld schreef:
> Op 07-07-11 18:23, Tom Lane schreef:
>> Karsten Hilbert<Karsten.Hilbert@gmx.net> writes:
>>> On Thu, Jul 07, 2011 at 11:14:05AM -0400, Tom Lane wrote:
>>>> I'm betting Debian hasn't fixed that bug yet either and so you need
>>>> this
>>>> post-beta2 patch:
>>>>
>>>> http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=c2ba0121c73b7461331104a46d140156e847572a
>>>>
>>
>>> Do they know about this gcc bug ?
>>
>> Can't say about Debian in particular, but upstream gcc certainly knows
>> about it.
>> https://bugzilla.redhat.com/show_bug.cgi?id=712480
>> http://gcc.gnu.org/bugzilla/show_bug.cgi?id=49390
>
> I'm guessing this is probably the cause of my problem, then. I'll try to
> rebuild with an earlier version of GCC, and let you know the results.

I've rebuilt with debian gcc 4.4.5-8 and am running 9.1 now without any
of the above problems. I've reported a bug for debian postgresql-9.1.
I've also seen that the current gcc-4.6 version for debian is 4.6.1, so
that shouldn't create any problems anymore (or at least the gcc bug is
marked as applied in 4.6.1 in the gcc bugtracker).

Thanks for all your time, guys!
Greetings, David

pgsql-general by date:

Previous
From: Vincent de Phily
Date:
Subject: Re: [PERFORM] DELETE taking too much memory
Next
From: Dean Rasheed
Date:
Subject: Re: DELETE taking too much memory