Re: select count(*) performance (vacuum did not help)

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: select count(*) performance (vacuum did not help)
Дата
Msg-id 2e78013d0709240723w7dc0379ai7f8b323f45439b15@mail.gmail.com
обсуждение исходный текст
Ответ на select count(*) performance (vacuum did not help)  (Gábor Farkas <gabor@nekomancer.net>)
Список pgsql-performance
Дерево обсуждения


On 9/24/07, Gábor Farkas <gabor@nekomancer.net> wrote:

INFO:  "main_activity": found 41001 removable, 11672 nonremovable row
versions in 160888 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 14029978 unused item pointers.
0 pages are entirely empty.
CPU 5.53s/1.71u sec elapsed 227.35 sec.
INFO:  analyzing "public.main_activity"
INFO:  "main_activity": 160888 pages, 4500 rows sampled, 4594 estimated
total rows


Looking at the number of rows vs number of pages, ISTM that VACUUM FULL
should help you.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

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

Предыдущее
От: brauagustin-susc@yahoo.com.ar
Дата:
Сообщение: Re: Low CPU Usage
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: select count(*) performance (vacuum did not help)