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: [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: [ADMIN] Query
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 table