Re: Clarification Regarding Vacuum and template1

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Clarification Regarding Vacuum and template1
Дата
Msg-id m31wye4t4v.fsf@mobile.int.cbbrowne.com
обсуждение исходный текст
Ответ на Re: Clarification Regarding Vacuum and template1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
>    So in practice,  should  one vacuum template1  when
> vacuuming other database (Assuming one doesn't use vaccumdb
> script when vacuuming database)?

In practice, it shouldn't be a big deal to vacuum template1 once in a
while, because, since it shouldn't have much data other than
pg_catalog tables in it, it shouldn't take long to vacuum it.

If you vacuum it once a day or once a week or such, the 15 seconds
won't take much out of the life of the disk drives...
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/postgresql.html
This login session:  $13.99

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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: UNION or OR / INTERSECT or AND ?
Следующее
От: Luki Rustianto
Дата:
Сообщение: Is there a way to limit CPU usage per user