Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6A99EB5DC00 for ; Fri, 8 Jul 2011 05:20:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 02978-02-4 for ; Fri, 8 Jul 2011 08:20:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.mendix.nl (smtp.mendix.nl [82.94.188.23]) by mail.postgresql.org (Postfix) with ESMTP id 169EAB5DC08 for ; Fri, 8 Jul 2011 05:19:57 -0300 (ADT) Received: from tingle.hq.mendix.net (tingle.hq.mendix.net [213.201.131.107]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.mendix.nl (Postfix) with ESMTPS id 75F061B3B; Fri, 8 Jul 2011 10:19:55 +0200 (CEST) Received: from win-srv01.MENDIXDOMAIN.local (toad.kantoor.mendix.nl [10.140.10.18]) by tingle.hq.mendix.net (Postfix) with ESMTP id 353EC57DA; Fri, 8 Jul 2011 10:19:55 +0200 (CEST) Received: from WIN-EXCHANGE-02.MENDIXDOMAIN.local ([10.140.10.10]) by win-srv01.MENDIXDOMAIN.local with Microsoft SMTPSVC(6.0.3790.4675); Fri, 8 Jul 2011 10:19:55 +0200 Received: from [10.140.10.139] (10.140.10.139) by Win-Exchange-02.MENDIXDOMAIN.local (10.140.10.11) with Microsoft SMTP Server (TLS) id 14.0.639.21; Fri, 8 Jul 2011 10:19:53 +0200 Message-ID: <4E16BDA9.30404@mendix.com> Date: Fri, 8 Jul 2011 10:19:53 +0200 From: David Hartveld User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:5.0) Gecko/20110624 Thunderbird/5.0 MIME-Version: 1.0 To: Josh Berkus CC: "pgsql-testers@postgresql.org" Subject: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow References: <0317654684C3CF48B06D8FF5AE5D2EE0CBBE@Win-Exchange-02.MENDIXDOMAIN.local> <4E15DA7E.70603@agliodbs.com> In-Reply-To: <4E15DA7E.70603@agliodbs.com> Content-Type: text/plain; charset="UTF-8"; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 08 Jul 2011 08:19:55.0132 (UTC) FILETIME=[D15BABC0:01CC3D47] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.419 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72 X-Spam-Level: ** X-Archive-Number: 201107/3 X-Sequence-Number: 252 Op 07-07-11 18:10, Josh Berkus schreef: >> The log on the master contains several lines with: >> LOG: could not send data to client: Connection reset by peer > > I haven't had time to test this myself yet. > > One question though: is it possible that you have significant network > issues on your setup? On pgsql-general, the following discussion has probably brought me to a solution (my binaries (from debian experimental) were built with a GCC version that contained an optimization bug): http://archives.postgresql.org/pgsql-general/2011-07/msg00175.php Thanks for your interest! David