Michael Shapiro wrote:
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote:
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.
Try EXPLAIN on that query.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
