| From: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
|---|---|
| To: | Aftab Ahmed Chandio <aftabac(at)siat(dot)ac(dot)cn> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time? |
| Date: | 2013-10-08 11:02:57 |
| Message-ID: | CAKoxK+6r9EVEX79Rv1OMdm83uF07d+wKW51zDPODZknMQ_5h6A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Tue, Oct 8, 2013 at 3:48 AM, Aftab Ahmed Chandio <aftabac(at)siat(dot)ac(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | janek12 | 2013-10-08 11:33:45 | pg_similarity |
| Previous Message | shailesh singh | 2013-10-08 10:55:59 | Urgent Help Required |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcelo Vega | 2013-10-08 15:31:03 | Is there a Maximum number of partitions in which constraint_exclusion works? |
| Previous Message | David Johnston | 2013-10-08 03:44:13 | Re: postgreSQL query via JDBC in different OS taking different running time? |