Re: PgAdmin startup query VERY slow

Поиск
Список
Период
Сортировка
От Michael Shapiro
Тема Re: PgAdmin startup query VERY slow
Дата
Msg-id 5.2.0.9.2.20040106152859.02a17ea8@pop.ncsa.uiuc.edu
обсуждение исходный текст
Ответ на Re: PgAdmin startup query VERY slow  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: PgAdmin startup query VERY slow  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
That seemed to fix it. What does VACUUM ANALYZE do that VACUUM FULL does
not? What causes a database to need vacuuming?



At 01:01 PM 1/6/2004 -0800, Josh Berkus wrote:
>Michael,
>
> > With a particular database, PgAdmin3 takes a very long time to connect
> to a
> > database. this is not a general problem with PgAdmin, but only with one
> > database out of many. Other databases do not have the problem. And only
> > with one particular server. The exact same database on a different server
> > does not have the problem.
>
>Have you run VACUUM ANALYZE *as the superuser* on the faulty server
>recently?
> >From the look of the explain, PG is grossly underestimating the number of
>items in the pg_trigger and pg_depend tables, and thus choosing an
>inappropriate nested loop execution.
>
>--
>-Josh Berkus
>  Aglio Database Solutions
>  San Francisco

---
Michael


В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: PgAdmin startup query VERY slow
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: PgAdmin startup query VERY slow