Re: Re: [GENERAL] Vacuum and Transactions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: [GENERAL] Vacuum and Transactions
Дата
Msg-id 29021.994533318@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Vacuum and Transactions  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Ответы RE: Re: [GENERAL] Vacuum and Transactions  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> Would 7.2 maintain performance when updating a row repeatedly (update,
> commit)?

You'll still need to VACUUM to get rid of the obsoleted versions of the
row.  The point of the planned 7.2 changes is to make VACUUM cheap and
nonintrusive enough so that you can run it frequently on tables that are
seeing continual updates.
        regards, tom lane


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

Предыдущее
От: Matthew Hagerty
Дата:
Сообщение: Re: Async PQgetResult() question.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Async PQgetResult() question.