Re: PgAdmin 3 startup

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