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
