Re: Slow temporary tables when using sync rep

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Slow temporary tables when using sync rep
Дата
Msg-id CAA-aLv480iRHOe71bATkf4YDuMjetWwf09dJKYmZQucgswt=jw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow temporary tables when using sync rep  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Slow temporary tables when using sync rep  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Дерево обсуждения 
On 17 April 2012 11:30, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> What happens is that we write the commit record if the transaction accesses
> a temporary table, but we don't flush it. However, we still wait until it's
> replicated to the standby. The obvious fix is to not wait for that, see
> attached.

Tested patch.  Yes, that fixes the problem.  Thanks.

-- 
Thom

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Slow temporary tables when using sync rep
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments