Re: [GENERAL] [ADMIN] Query performance difference

2008-08-21 Thread Travis Smith
mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 3:22 PM To: Travis Smith; pgsql-general@postgresql.org Subject: Re: [ADMIN] Query performance difference What do you want to say? Please give details. I got an explain from PGAdmin, as follows "GroupAggregate (cost=28927.37..35594.39 rows=1

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