Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time? - Mailing list pgsql-performance

From Luca Ferrari
Subject Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?
Date
Msg-id CAKoxK+6r9EVEX79Rv1OMdm83uF07d+wKW51zDPODZknMQ_5h6A@mail.gmail.com
Whole thread Raw
List pgsql-performance
On Tue, Oct 8, 2013 at 3:48 AM, Aftab Ahmed Chandio <aftabac@siat.ac.cn> wrote:
> What do u suggest me, where I need to make performance tuning? w hich
> configuration setting must need to modify in the linux?

Well, others have already pointed out that you should first measure
your query on the server. I would point out that the JVM itself could
be different or differently configured on Linux/win machines, and this
will lead to different results.
Second it is not clear to me why are you measuring the same query on
different machines and OSs, or better, why are you assuming the
resulting time should be the same.

Luca


pgsql-performance by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?
Next
From: Marcelo Vega
Date:
Subject: Is there a Maximum number of partitions in which constraint_exclusion works?