What do you want to say? Please give details. I got an explain from PGAdmin, as follows "GroupAggregate (cost=28927.37..35594.39 rows=156871 width=24)" " -> Sort (cost=28927.37..29319.55 rows=156871 width=24)" " Sort Key: docacctransactions.accgroupid, docs.docid, docs.docdate" " -> Hash Join (cost=3337.89..12170.02 rows=156871 width=24)" " Hash Cond: (docacctransactions.docid = docs.docid)" " -> Seq Scan on docacctransactions (cost=0.00..3665.71 rows=156871 width=20)" " -> Hash (cost=2545.06..2545.06 rows=48306 width=8)" " -> Seq Scan on docs (cost=0.00..2545.06 rows=48306 width=8)"
Can you please give why there is a time difference? CPK On Fri, Aug 22, 2008 at 1:44 AM, Travis Smith <[EMAIL PROTECTED]>wrote: > It may be worth-wile to generate an explain plan > > > > http://www.postgresql.org/docs/8.3/interactive/sql-explain.html > > > > > > > > > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *c k > *Sent:* Thursday, August 21, 2008 2:49 PM > *To:* pgsql-general@postgresql.org; [EMAIL PROTECTED] > *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 confidential use of the individual or entity to > which it is addressed and may contain information that is proprietary 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 communication 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 transmission > cannot be guaranteed to be secure or error-free. P6070214 >
