Re: Insert only tables and vacuum performance

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: Insert only tables and vacuum performance
Дата
Msg-id 4091A381.3020307@selectacast.net
обсуждение исходный текст
Ответ на Re: Insert only tables and vacuum performance  (Rod Taylor <pg@rbt.ca>)
Список pgsql-performance
Rod Taylor wrote:
>>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 if most of the table is never updated then the inserts would tend to
be at the end, right?

> But anyway,
> how do you handle a rolled back insert?
>
It is considered like a deleted row to be vacuumed.

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

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