How do I cut and paste the results (in the Data Output window) so I can send them to you. The normal highlight / cut/paste doesn't seem to work.

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:

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


---
Michael



---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to