Horton

Re: sloooow query

Marie G. Tuite <marie.tuite@edisonaffiliates.com>

View thread View on postgr.es
From: "Marie G. Tuite" <marie.tuite@edisonaffiliates.com>
To: "Pgsql-Performance@Postgresql. Org" <pgsql-performance@postgresql.org>
Date: 2002-10-07T22:12:41Z
Lists: pgsql-performance, pgsql-general 
> 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.

I have vacuumed, analysed and reindexed.