Re: Indexes and Tables: Growth and Treatment

Поиск
Список
Период
Сортировка
От Thomas F.O'Connell
Тема Re: Indexes and Tables: Growth and Treatment
Дата
Msg-id 90371CE6-D8D9-11D8-B910-000D93AE0944@sitening.com
обсуждение исходный текст
Ответ на Re: Indexes and Tables: Growth and Treatment (Modified by Thomas F. O'Connell)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom,

If I've got the RAM, should I have max_fsm_relations be large enough to
cover _all_ user tables and indexes?

Thanks!

-tfo

On Jul 13, 2004, at 6:58 PM, Tom Lane wrote:

> Try hourly vacuums.  If that doesn't stem the tide, make it more often
> (or try autovacuum).  Also make sure that your FSM settings are large
> enough; if they're not then no amount of plain vacuuming will keep you
> out of trouble.


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

Предыдущее
От: "zuhans@iname.com"
Дата:
Сообщение: more intelligence to pg_dump
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Can someone please explain this error