I have analyzed, vacuumed and reindexed.
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Monday, October 07, 2002 3:58 PM
> To: marie(dot)tuite(at)edisonaffiliates(dot)com
> Cc: josh(at)agliodbs(dot)com; pgsql-performance(at)postgresql(dot)org
> Subject: Re: [pgsql-performance] sloooow query
>
>
> "Marie G. Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)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
>