Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit

Поиск

Список

Период

Сортировка

От	Tom Lane
Тема	Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
Дата	16 марта 2008 г. 23:21:02
Msg-id	20891.1205720439@sss.pgh.pa.us обсуждение
Ответ на	Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список	pgsql-patches

Дерево обсуждения

"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> Yep, patch attached. I also changed xactGetCommittedChildren to return
> the original array instead of copying it, as Alvaro suggested.

Applied with minor corrections (mostly comment fixes, but there were
a couple of real mistakes).

            regards, tom lane

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit