Re: sloooow query

I have analyzed, vacuumed and reindexed.

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Monday, October 07, 2002 3:58 PM
> To: marie.tuite@edisonaffiliates.com
> Cc: josh@agliodbs.com; pgsql-performance@postgresql.org
> Subject: Re: [pgsql-performance] 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
>