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

Поиск
Список
Период
Сортировка
От Gábor Farkas
Тема Re: select count(*) performance (vacuum did not help)
Дата
Msg-id 46F7D453.4050908@nekomancer.net
обсуждение исходный текст
Ответ на Re: select count(*) performance (vacuum did not help)  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Ответы Re: select count(*) performance (vacuum did not help)  (Bill Moran <wmoran@collaborativefusion.com>)
Re: select count(*) performance (vacuum did not help)  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: select count(*) performance (vacuum did not help)  ("Dave Dutcher" <dave@tridecap.com>)
Список pgsql-performance
Heikki Linnakangas wrote:
> Gábor Farkas wrote:
>>
>> if i do a full vacuum to that table only, will the database still serve
>> data from the other tables at a normal speed?
>
> Yes. The extra I/O load vacuum full generates while it's running might
> disrupt other activity, though.
>

i see.

will i achieve the same thing by simply dropping that table and
re-creating it?

gabor

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

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: select count(*) performance (vacuum did not help)
Следующее
От: "Fabiola Fernández"
Дата:
Сообщение: TEXT or LONGTEXT?