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.
---
Michael
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
