Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TzYlP-0006MO-Aj for pgsql-performance@arkaria.postgresql.org; Sun, 27 Jan 2013 20:23:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TzYlO-0008Bp-7I for pgsql-performance@arkaria.postgresql.org; Sun, 27 Jan 2013 20:23:38 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TzYlN-0008Bk-DA for pgsql-performance@postgresql.org; Sun, 27 Jan 2013 20:23:37 +0000 Received: from mail-pa0-f41.google.com ([209.85.220.41]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TzYlI-0006rr-Tt for pgsql-performance@postgresql.org; Sun, 27 Jan 2013 20:23:36 +0000 Received: by mail-pa0-f41.google.com with SMTP id bj3so1135078pad.28 for ; Sun, 27 Jan 2013 12:23:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:from:to:references:in-reply-to:subject:date:message-id :mime-version:content-type:content-transfer-encoding:x-mailer :thread-index:content-language; bh=EAFgZpEANsiMHZiMQr6X835rJcoM0nM2LxuAPwPSSRc=; b=zbZmfn5B0KJiipPRsQbG2YdpOUoput6amxxN9lZFvu8dP8PdbtX11qo14Um3hgKsIT f1yoo05iBiWFATVd6mPhtoifoQonu9S4lUlZBFWPklIpiOw2+1tMLc+A7LTlc0DYNajX zbqEoUjL733G64O1/rTnMvq6b1q6O+IOlGvJA+9yGqAWMDSL2HSAD+MMvCxxzfyrSACm Ixviq6WFjweodnjeayxDT6yTVPTnW8zp3FWAChYtrvBl0s8lkLwdmQp6403wVld/omDJ O7le6KNNN7SDICmHTSGpDe+/Pod9WwuumUsXqb8btXdd2vutjJ5KHrm7ZK4gKj5LMmHI 0dpQ== X-Received: by 10.66.85.200 with SMTP id j8mr30801596paz.19.1359318211180; Sun, 27 Jan 2013 12:23:31 -0800 (PST) Received: from device ([60.234.160.157]) by mx.google.com with ESMTPS id sk1sm4869690pbc.0.2013.01.27.12.23.29 (version=TLSv1 cipher=RC4-SHA bits=128/128); Sun, 27 Jan 2013 12:23:30 -0800 (PST) From: "David Rowley" To: "'belal hamed'" , References: In-Reply-To: Subject: Re: PostgreSQL over internet Date: Mon, 28 Jan 2013 09:23:24 +1300 Message-ID: <001b01cdfccc$2b5fa9b0$821efd10$@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQI/TRbhcf91uTK4YBctjf6PQ+E33Zd6/SiQ Content-Language: en-gb X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of belal hamed > Sent: 27 January 2013 13:16 > To: pgsql-performance@postgresql.org > Subject: [PERFORM] PostgreSQL over internet > by wireshark I monitor TCP packets I found total data transmit/received 400B > I took about 2.5s to fetch results=A0 why ?????? Are you sure there's not any QOS somewhere that is slowing down the packets for port 5432 or whichever you're using for PostgreSQL? Perhaps temporarily changing PostgreSQL's listening port to something else might be a good test. David --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance