Re: autovacuum and reloptions

Поиск
Список
Период
Сортировка
От Euler Taveira de Oliveira
Тема Re: autovacuum and reloptions
Дата
Msg-id 498B9FAB.8040002@timbira.com
обсуждение исходный текст
Ответ на Re: autovacuum and reloptions  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: autovacuum and reloptions
Список pgsql-hackers
Alvaro Herrera escreveu:
> So here's what looks like a committable patch.
> 
> Note to self: remember to remove src/include/catalog/pg_autovacuum.h and
> to bump catversion.
> 
> 
Works for me. Just a few comments.

(i) I don't like this construction "by entries by changing storage
parameters". I prefer "by changing storage parameters" or "by entries in
pg_class.reloptions";

(ii) I think we should change the expression "storage parameters" for
something else because autovacuum is related to maintenance. My suggestion is
a general expression like "relation parameters";

(iii) I noticed that GUC defaults and relopt defaults are different
(autovacuum_cost_delay and autovacuum_cost_limit). Is there any reason for not
using -1?

(iv) Maybe we should document that pg_dump will only dump reloptions like
toast.foo iff the relation has an associated TOAST table. This seems obvious
but ...


--  Euler Taveira de Oliveira http://www.timbira.com/


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: new GUC var: autovacuum_process_all_tables
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Synch Replication