Skip site navigation (1) Skip section navigation (2)

Re: PgAdmin 3 startup

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Michael Shapiro <mshapiro(at)ncsa(dot)edu>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: PgAdmin 3 startup
Date: 2003-12-31 14:09:53
Message-ID: 3FF2D8B1.3030601@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
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



In response to

Responses

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-12-31 14:11:30
Subject: Re: Crash
Previous:From: Dave PageDate: 2003-12-31 10:58:51
Subject: Re: Crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group