PgAdmin 3 startup
PgAdmin 3 startup
От:
Michael Shapiro <mshapiro@ncsa.edu>
Дата:
I have downloaded the latest snapshot of pgadmin3 (pgadmin3-20031228-Win32.zip) and connected to a database. PgAmin takes 150 seconds to complete its startup. (I have reported this problem previously, but just wanted to let you know that it remains with this snapshot) --- Michael
Re: PgAdmin 3 startup
От:
Michael Shapiro <mshapiro@ncsa.edu>
Дата:
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
