Re: slow commits with heavy temp table usage in 8.4.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: slow commits with heavy temp table usage in 8.4.0
Дата
Msg-id 23440.1249661768@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: slow commits with heavy temp table usage in 8.4.0  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Ответы Re: slow commits with heavy temp table usage in 8.4.0  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Список pgsql-hackers
"Todd A. Cook" <tcook@blackducksoftware.com> writes:
> Tom Lane wrote:
>> The attached prototype patch does this
>> and seems to fix the speed problem nicely.  It's not tremendously
>> well tested, but perhaps you'd like to test?  Should work in 8.4.

> With the patch applied, the test only took 35 seconds, and the commit
> was practically instant (30ms).

I know it's faster, what I meant by testing was does it *work*.  If you
roll back a truncate, do you get the expected state?  How about after a
database crash?

> Is there any chance that it will be backpatched to 8.4?

Not a lot.
        regards, tom lane


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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: Review: Revise parallel pg_restore's scheduling heuristic
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Fixing geometic calculation