Re: sloooow query

Marie,

> I ran the vacuum for selected tables.  It looks fine, I think, but I amn't
> always sure what I am reading in output.

So much for the easy answer.   The reason I wanted to see a VACUUM FULL is
that the query on the "bad" database is taking a long time to return even the
first row of many of its sub-parts.  This is usually the result of not
running VACUUM FULL after a lot of deletions.

However, your problem apparently is something else.   Is is possible that
there is some kind of disk access problem for the bad database copy?  Is
there a difference in where its files are physically located?


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco