Re: FW: [GENERAL] Slow query performance

2008-10-29 Thread Kevin Galligan
Oct 29, 2008 at 7:52 PM, Dann Corbit <[EMAIL PROTECTED]> wrote: >*From:* Kevin Galligan [mailto:[EMAIL PROTECTED] > *Sent:* Wednesday, October 29, 2008 4:34 PM > *To:* Dann Corbit > *Cc:* pgsql-general@postgresql.org > *Subject:* Re: FW: [GENERAL] Slow query performan

Re: FW: [GENERAL] Slow query performance

2008-10-29 Thread Dann Corbit
From: Kevin Galligan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2008 4:34 PM To: Dann Corbit Cc: pgsql-general@postgresql.org Subject: Re: FW: [GENERAL] Slow query performance Sorry for the lack of detail. Index on both state and age. Not a clustered on both as the queries are

FW: [GENERAL] Slow query performance

2008-10-29 Thread Dann Corbit
From: Kevin Galligan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2008 3:16 PM To: Dann Corbit Subject: Re: [GENERAL] Slow query performance Columns are as follows: account | integer | city | character varying(20) | zip | character(5) | dincome | ch