Re: sloooow query

Marie,

> I pg_dumped the first database having performance problems and reloaded it
> into a new database on the same server.  The query ran normally when I
> reloaded it.  There is no difference in hardware, schema or anything else.

That's a pretty brutal query.

From the comparison between the two queries, it looks like you have a lot of
discarded rows cluttering up the original database, just like I did.

What happens if you run VACUUM FULL VERBOSE on the Bad database?  Does it
report lots of rows taken up?

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology     josh@agliodbs.com
    and data management solutions     (415) 565-7293
   for law firms, small businesses      fax 621-2533
    and non-profit organizations.     San Francisco