Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 8CAAA1337B80 for ; Sat, 15 Jan 2011 09:37:09 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 35186-04 for ; Sat, 15 Jan 2011 13:37:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [173.230.139.50]) by mail.postgresql.org (Postfix) with ESMTP id 420101337B7A for ; Sat, 15 Jan 2011 09:37:01 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by www.postnewspapers.com.au (Postfix) with ESMTP id 7719714B9; Sat, 15 Jan 2011 08:37:01 -0500 (EST) X-Virus-Scanned: amavisd-new at postnewspapers.com.au.com Received: from www.postnewspapers.com.au ([127.0.0.1]) by localhost (www.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id CQCMRW4U8-pi; Sat, 15 Jan 2011 08:36:59 -0500 (EST) Received: from mail.postnewspapers.com.au (ppp171-128.static.internode.on.net [150.101.171.128]) by www.postnewspapers.com.au (Postfix) with ESMTP id E8E333E; Sat, 15 Jan 2011 08:36:58 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id B0794AE3BD; Sat, 15 Jan 2011 21:36:57 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id ypCPW21XYATo; Sat, 15 Jan 2011 21:36:47 +0800 (WST) Received: from [10.1.1.5] (58-7-214-236.dyn.iinet.net.au [58.7.214.236]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id C4271AE375; Sat, 15 Jan 2011 21:36:46 +0800 (WST) Message-ID: <4D31A2EC.1070401@postnewspapers.com.au> Date: Sat, 15 Jan 2011 21:36:44 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.13) Gecko/20101209 Fedora/3.1.7-0.35.b3pre.fc14 Thunderbird/3.1.7 MIME-Version: 1.0 To: Mladen Gogala , "pgsql-performance@postgresql.org" Subject: Re: The good, old times References: <4D2DB14D.9070403@vmsinfo.com> <87hbdeqkbg.fsf@meuh.mnc.lan> <4D2FE6F4.5020201@postnewspapers.com.au> <4D307FDB.5090709@vmsinfo.com> In-Reply-To: <4D307FDB.5090709@vmsinfo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_40=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/117 X-Sequence-Number: 41904 On 01/15/2011 12:54 AM, Mladen Gogala wrote: > Yes, it was a complaint about the download speed. > >> - Information abut their local connectivity >> - mtr --report / traceroute output >> - tests from other available hosts OK, that's one out of three. How about the other two? > 15 gayrettepe-t3-1-gayrettepe-t2-1.turktelekom.com.tr (212.156.118.29) > 167.867 ms 167.870 ms 167.862 ms > 16 88.255.240.110 (88.255.240.110) 167.515 ms 168.172 ms 165.829 ms > 17 ns1.gunduz.org (77.79.103.58) 171.574 ms !X * * Output from a smarter traceroute client like "mtr" would be helpful. See below for usage. "mtr" is available for most non-braindead unixes, and is pre-installed on many modern Linux variants. > Are there any good mirrors? Apparently, there is something slow in the > force. Looks fine from here, on iiNet Western Australian ADSL2+ via local 802.11g . That latency is about what I expect for traffic from Western Australia to Turkey via Sydney and the USA. I see similar results from other hosts. Performance when accessing the server is fine. This sample was taken Sat Jan 15 2011, 21:35:55 +0800 time. > [craig@ayaki ~]$ mtr --report-wide --report 77.79.103.58 > HOST: ayaki Loss% Snt Last Avg Best Wrst StDev > 1.|-- bob.iad 0.0% 10 1.9 1.9 1.2 3.7 0.7 > 2.|-- nexthop.wa.iinet.net.au 0.0% 10 16.7 18.6 16.7 28.8 3.7 > 3.|-- te7-2.per-qv1-bdr1.iinet.net.au 0.0% 10 17.7 17.8 17.1 18.6 0.4 > 4.|-- te3-0-0.syd-ult-core1.iinet.net.au 0.0% 10 72.9 72.1 71.4 72.9 0.6 > 5.|-- Bundle-Ether12.chw48.Sydney.telstra.net 0.0% 10 69.3 69.3 68.5 70.3 0.7 > 6.|-- Bundle-Ether6.chw-core2.Sydney.telstra.net 0.0% 10 73.2 73.7 73.1 76.1 0.9 > 7.|-- Bundle-Ether1.oxf-gw2.Sydney.telstra.net 0.0% 10 74.5 75.1 72.6 81.9 3.3 > 8.|-- 203.50.13.102 0.0% 10 70.1 70.5 69.4 72.0 0.8 > 9.|-- i-10-0-0.syd-core03.bi.reach.com 0.0% 10 75.9 75.8 75.0 76.5 0.5 > 10.|-- i-0-3-0-0.1wlt-core01.bx.reach.com 0.0% 10 224.6 223.2 222.5 224.6 0.6 > 11.|-- i-3-4.eqla01.bi.reach.com 0.0% 10 222.2 222.2 221.5 223.4 0.6 > 12.|-- gblx-peer.eqla01.pr.reach.com 0.0% 10 248.0 247.8 246.9 248.4 0.5 > 13.|-- 204.245.38.154 20.0% 10 638.2 520.0 465.1 638.2 71.4 > 14.|-- static.turktelekom.com.tr 10.0% 10 475.1 475.1 471.9 479.8 2.1 > 15.|-- gayrettepe-t3-1-gayrettepe-t2-1.turktelekom.com.tr 10.0% 10 476.2 475.3 472.0 476.8 1.8 > 16.|-- 88.255.240.110 10.0% 10 481.9 490.0 480.6 528.8 15.0 > 17.|-- ??? 100.0 10 0.0 0.0 0.0 0.0 0.0 > 18.|-- ns1.gunduz.org 20.0% 10 483.5 482.3 476.7 485.0 2.7 -- Craig Ringer