Tom Polak <tom@rockfordarearealtors.org> wrote:
> the best I could get it to was 7.5 seconds.
> select name,address,city,state,statename,stateid,other from
> pgtemp1 left join pgtemp2 on state=stateid
We'd need a lot more information. Please read this and post again:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
Be sure to include hardware info, postgresql.conf settings
(excluding comments), table layouts including indexes and
constraints, and the results of:
EXPLAIN ANALYZE select ...
-Kevin