Re: Insert only tables and vacuum performance

Поиск
Список
Период
Сортировка
Искать
От
Rod Taylor
Тема
Re: Insert only tables and vacuum performance
Дата
Msg-id
1083285855.30065.462.camel@jester
Ответ на
Список
Дерево обсуждения
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>
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>
Re: Insert only tables and vacuum performance Joseph Shraibman <jks@selectacast.net>
Re: Insert only tables and vacuum performance Rod Taylor <pg@rbt.ca>
Re: Insert only tables and vacuum performance Joseph Shraibman <jks@selectacast.net>
> 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
Дата:
От: Joseph Shraibman
Дата:
FAQ