Re: PgAdmin startup query VERY slow - Mailing list pgsql-performance

From Josh Berkus
Subject Re: PgAdmin startup query VERY slow
Date
Msg-id 200401061317.30877.josh@agliodbs.com
Whole thread Raw
In response to Re: PgAdmin startup query VERY slow  (Michael Shapiro <mshapiro@ncsa.edu>)
Responses Re: PgAdmin startup query VERY slow
List pgsql-performance
Mark,

> That seemed to fix it. What does VACUUM ANALYZE do that VACUUM FULL does
> not? What causes a database to need vacuuming?

See the Online Docs:
http://www.postgresql.org/docs/current/static/maintenance.html

Incidentally, just ANALYZE would probably have fixed your problem.   Please do
suggest to the PGAdmin team that they add a FAQ item about this.


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Michael Shapiro
Date:
Subject: Re: PgAdmin startup query VERY slow
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Select max(foo) and select count(*) optimization