Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VTMax-0001ur-81 for pgsql-general@arkaria.postgresql.org; Tue, 08 Oct 2013 02:00:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VTMaw-0003ll-Gm for pgsql-general@arkaria.postgresql.org; Tue, 08 Oct 2013 02:00:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VTMPa-0002VN-S3; Tue, 08 Oct 2013 01:48:34 +0000 Received: from smtp15.cstnet.cn ([2001:cc0:2fff:7::15] helo=cstnet.cn) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VTMPT-0003kB-DZ; Tue, 08 Oct 2013 01:48:32 +0000 Received: by ajax-webmail-app6 (Coremail) ; Tue, 8 Oct 2013 09:48:18 +0800 (GMT+08:00) Date: Tue, 8 Oct 2013 09:48:18 +0800 (GMT+08:00) From: "Aftab Ahmed Chandio" To: pgsql-general@postgresql.org, pgsql-performance@postgresql.org Message-ID: <1bf97f3.3e260.14195c01fd6.Coremail.aftabac@siat.ac.cn> Subject: postgreSQL query via JDBC in different OS taking different running time? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_894138_1805316.1381196898261" X-Originating-IP: [210.75.252.235] X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT2.1.10 dev build 20130508(22118.5358.5168) Copyright (c) 2002-2013 www.mailtech.cn cstnet X-SendMailWithSms: false X-CM-CTRLDATA: 3M/XxGZvb3Rlcl9odG09MTY2MDoxMiZmb290ZXJfdHh0PTE0NDg6Ng== X-CM-TRANSID: UgCowJBL9ARiZFNSiTiRAA--.34514W X-CM-SenderInfo: pdiwtu1df62x1dwotugofq/1tbiAxEGB1D7NlwG5gABsz X-Coremail-Antispam: 1Ur529EdanIXcx71UUUUU7IcSsGvfJ3iIAIbVAYjsxI4VWxJw CS07vEb4IE77IF4wCS07vE1I0E4x80FVAKz4kxMIAIbVAFxVCaYxvI4VCIwcAKzIAtYxBI daVFxhVjvjDU= X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org ------=_Part_894138_1805316.1381196898261 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: 7bit Hi, I want to know the reason behind the case: My query processes from JDBC (Java Program) to PostgreSQL. I use system time by invoking java function, I collect one time unit before the query statement perform and second after the execution of query statement. I found 85 ms time unit in DOS (win7) (laptop 4cores). both Java and PostgreSQL installed and invoked on the same machine, respectively. On the other hand, I use same process (separate installation) on linux on 8 cores physical machine with 2times greater then laptop. I found 150 ms. (which is a question for me because the time in Linux environment should give me half of the time taking on laptop) I also make same setting of postgresql.conf in the linux setup, which is available same in the win7 setup, because win7 setup gives better performance of the query. What do u suggest me, where I need to make performance tuning? which configuration setting must need to modify in the linux? * laptop RAM 4 GB and Linux machine 32 GB looking positive response. -- Aftab A. Chandio PhD Scholar(Research Center for Cloud Computing) Shenzhen Institutes of Advanced Technology, Chinese Academy of Sciences 7th Floor, Shenzhen Cloud Computing Center at National Supercomputing Center in Shenzhen (NSCS) Xueyuan B.1068, University Town, Xili, Shenzhen, China. +86 13244762252 Lecturer Institutes of Mathematics & Computer Science University of Sindh, Jamshoro, Pakistan. +92 3003038843 ------=_Part_894138_1805316.1381196898261 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: 7bit
Hi,
I want to know the reason behind the case:
My query processes from JDBC (Java Program) to PostgreSQL. I use system time by invoking java function, I collect one time unit before the query statement perform and second after the execution of query statement. 
I found 85 ms time unit in DOS (win7) (laptop 4cores). both Java and PostgreSQL installed and invoked on the same machine, respectively.
On the other hand, I use same process (separate installation) on linux on 8 cores physical machine with 2times greater then laptop. 
I found 150 ms. (which is a question for me because the time in Linux environment should give me half of the time taking on laptop)
I also make same setting  of postgresql.conf in the linux setup, which is available same in the win7  setup, because win7 setup gives better performance of the query.
What do u suggest me, where I need to make performance tuning? which configuration setting must need to modify in the linux?
 * laptop RAM 4 GB and Linux machine 32 GB
looking positive response.


--

Aftab A. Chandio
PhD Scholar(Research Center for Cloud Computing)
Shenzhen Institutes of Advanced Technology, Chinese Academy of Sciences
7th Floor, Shenzhen Cloud Computing Center at National Supercomputing Center in Shenzhen (NSCS)
Xueyuan B.1068, University Town, Xili, Shenzhen, China.
+86 13244762252

Lecturer
Institutes of Mathematics & Computer Science
University of Sindh, Jamshoro, Pakistan.
+92 3003038843



------=_Part_894138_1805316.1381196898261--