Re: Really really slow select count(*)

Поиск
Список
Период
Сортировка
От felix
Тема Re: Really really slow select count(*)
Дата
Msg-id AANLkTi=3n_W-OFVuVHx3Tthn_KiMN42BturJUS5BuWVz@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Really really slow select count(*)  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance

vacuumdb -a -v -z -U postgres -W &> vacuum.log

that's all, isn't it ?

it did each db

8.3 in case that matters

the very end:

There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  analyzing "public.seo_partnerlinkcategory"
INFO:  "seo_partnerlinkcategory": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows



On Fri, Feb 4, 2011 at 6:40 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

> I tried it with all databases too

I believe you have to run it on the whole db to get that output.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Really really slow select count(*)
Следующее
От: Shaun Thomas
Дата:
Сообщение: Re: Really really slow select count(*)