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

[ADMIN] Query performance difference

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