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

Re: PgAdmin 3 startup

From: Michael Shapiro <mshapiro(at)ncsa(dot)edu>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: PgAdmin 3 startup
Date: 2004-01-05 17:59:17
Message-ID: 5.2.0.9.2.20040105115909.030b4dc8@pop.ncsa.uiuc.edu (view raw or flat)
Thread:
Lists: pgadmin-support
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 

Attachment: pgadmin.txt
Description: text/plain (30.1 KB)

In response to

Responses

pgadmin-support by date

Next:From: Michael SerdarDate: 2004-01-05 20:46:47
Subject: Need improved support for connection timeouts
Previous:From: Michael ShapiroDate: 2004-01-05 17:17:18
Subject: Re: PgAdmin 3 startup

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