Re: Why pgAdmin III guru suggests VACUUM in 8.1

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: Why pgAdmin III guru suggests VACUUM in 8.1
Дата
Msg-id dmku6j$1emi$1@news.hub.org
обсуждение исходный текст
Ответ на Why pgAdmin III guru suggests VACUUM in 8.1  ("Andrus Moor" <eetasoft@online.ee>)
Список pgsql-general
>> I need to create installation for dumb users to ship DBMS with my
>> application.
>> So manual initial tuning is not possible.
>>
>
> Some tuning is... for instance during installation you should run vacuum
> analyze after loading your data in.

My application runs ANALYZE command programmatically after data loading.
So end user does not need to run it.

Autovacuum is turned ON by default.
Why I should to run VACUUM ANALYZE in this case ?
ANALYZE  must be sufficient.


Andrus.



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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: What is the deal with mailing lists?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: How to change database owner in 7.4