Skip site navigation (1) Skip section navigation (2)

Re: Query performance difference

From: Travis Smith <tsmith(at)optionshouse(dot)com>
To: 'c k' <shreeseva(dot)learning(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org"<pgsql-general(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org"<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Query performance difference
Date: 2008-08-21 20:14:34
Message-ID: D337038284820142B2A3196D1BFE2B470F78E403@spswchi6mail1.peak6.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
It may be worth-wile  to generate an explain plan

http://www.postgresql.org/docs/8.3/interactive/sql-explain.html




From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of c k
Sent: Thursday, August 21, 2008 2:49 PM
To: pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Query performance difference

Hello,
I have a question regarding query performance from two pgsql applications. PGadmin III 1.8 and Navicat for postgresql 8. Both connected to same server on local machine 8.3 and runs a same query for appox. 1,60,000 rows with one min, one max and addition of the min and max values on two tables joined on an integer column gives different query execution times with noticible difference. PGAdmin gives 9350ms and Navicat gives 2110ms. Why? What will be the difference?
Is it in their query execution methods, with/without indexes etc?.
Thanks

CPK

_______________________________________________________

The  information in this email or in any file attached
hereto is intended only for the personal and confiden-
tial  use  of  the individual or entity to which it is
addressed and may contain information that is  propri-
etary  and  confidential.  If you are not the intended
recipient of this message you are hereby notified that
any  review, dissemination, distribution or copying of
this message is strictly prohibited.  This  communica-
tion  is  for information purposes only and should not
be regarded as an offer to sell or as  a  solicitation
of an offer to buy any financial product. Email trans-
mission cannot be guaranteed to be  secure  or  error-
free. P6070214

In response to

Responses

pgsql-admin by date

Next:From: c kDate: 2008-08-21 20:21:45
Subject: Re: [ADMIN] Query performance difference
Previous:From: c kDate: 2008-08-21 19:48:51
Subject: Query performance difference

pgsql-general by date

Next:From: c kDate: 2008-08-21 20:21:45
Subject: Re: [ADMIN] Query performance difference
Previous:From: Peter BillenDate: 2008-08-21 20:09:50
Subject: Re: SERIAL datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group