Re: Frequently updated tables

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Frequently updated tables
Дата
Msg-id 40C65FD8.2030104@coretech.co.nz
обсуждение исходный текст
Ответ на Re: Frequently updated tables  (pgsql@mohawksoft.com)
Ответы Re: Frequently updated tables  (pgsql@mohawksoft.com)
Список pgsql-hackers
pgsql@mohawksoft.com wrote:

>The best phrasing would be "the accumulating overhead of deletes and
>updates."
>
>Yes.
>  
>

Are you using 7.3?

I am asking because in 7.3 high update / delete tables could suffer 
(index and toast) bloat that was untamable via (lazy) VACUUM and FSM.
I believe this is fixed in 7.4, so it should be possible to achieve on 
disk size control of tables / indexes by configuring FSM and (lazy) 
VACUUM. Did you find this not to be the case?

regards

Mark


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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: [pgsql-www] Collaboration Tool Proposal
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: bug in 7.4 SET WITHOUT OIDs