At 03:09 PM 12/31/2003 +0100, Andreas Pflug wrote:
Michael Shapiro wrote:
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote:Try EXPLAIN on that query.
Michael,
Michael Shapiro wrote:
The only clue that I might be able to offer you is that we have dropped and recreated the schemas in the database many many times without dropping and recreating the database. Might that cause this query to run slowly?
Yes, that's why I mentioned VACUUMing.
Regards, Andreas
However, vacuuming did not speed this up. So the question remains.. why so slow on the one database while al the others are fast.
Regards, Andreas
---
Michael
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings