Insert only tables and vacuum performance

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Insert only tables and vacuum performance
Дата
Msg-id c6s1t4$1au1$1@news.hub.org
обсуждение исходный текст
Ответы Re: Insert only tables and vacuum performance  (Joseph Shraibman <jks@selectacast.net>)
Re: Insert only tables and vacuum performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
I have a table that is never updated, only INSERTED into. Is there a way
I can prevent vacuum wasting time on this table besides vacuuming each
table in the db by itself and omitting this table?

How feasable would it be to have a marker somewhere in pg that is
"updated since last vacuum" that would be cleared when vacuum runs, and
if set vacuum will ignore that table?

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

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: analyzer/planner and clustered rows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: planner/optimizer question