Re: Insert only tables and vacuum performance

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Insert only tables and vacuum performance
Дата
Msg-id 1083285855.30065.462.camel@jester
обсуждение исходный текст
Ответ на Re: Insert only tables and vacuum performance  (Joseph Shraibman <jks@selectacast.net>)
Ответы Re: Insert only tables and vacuum performance  (Joseph Shraibman <jks@selectacast.net>)
Список pgsql-performance
> Or even better an offset into the datatable for the earliest deleted
> row, so if you have a table where you update the row shortly after
> insert and then never touch it vacuum can skip most of the table
> (inserts are done at the end of the table, right?)

Inserts are done at the end of the table as a last resort. But anyway,
how do you handle a rolled back insert?



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

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: why can't 2 indexes be used at once?
Следующее
От: Joseph Shraibman
Дата:
Сообщение: Re: Insert only tables and vacuum performance