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