Re: PgAdmin startup query VERY slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PgAdmin startup query VERY slow
Дата
Msg-id 1687.1073430755@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PgAdmin startup query VERY slow  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> Incidentally, just ANALYZE would probably have fixed your problem.

... or just VACUUM; that would have updated the row count which is all
that was really needed here.  The main point is that you do have to do
that as superuser, since the same commands issued as a non-superuser
won't touch the system tables (or any table you do not own).

            regards, tom lane

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

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Select max(foo) and select count(*) optimization
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Select max(foo) and select count(*) optimization