Re: sloooow query

"Marie G. Tuite" <marie.tuite@edisonaffiliates.com> writes:
> 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.

Have you done an ANALYZE or VACUUM ANALYZE in either database?  The
statistics the planner is working from seem to be quite different
in the two plans.

            regards, tom lane