Re: [GENERAL] [ADMIN] Query performance difference

2008-08-21 Thread Travis Smith
My suggestion was based on your question .. >Why? What will be the difference? >Is it in their query execution methods, with/without indexes etc?. An explain plan would tell you what the execution path is. This should be the same independent of the front end you use. Things such as drivers, ne

Re: [GENERAL] [ADMIN] Query performance difference

2008-08-21 Thread c k
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" "

Re: [GENERAL] [ADMIN] Query performance difference

2008-08-21 Thread Travis Smith
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] Quer