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]
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
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,
