Re: Slow temporary tables when using sync rep - Mailing list pgsql-hackers

From Thom Brown
Subject Re: Slow temporary tables when using sync rep
Date
Msg-id CAA-aLv6wSAQ6RFUDpE-5n51JP0f2iwPnSN4byz1H-DnA-ivgWA@mail.gmail.com
Whole thread Raw
In response to Re: Slow temporary tables when using sync rep  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On 17 April 2012 14:35, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> On 17.04.2012 14:10, Thom Brown wrote:
>>
>> 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.
>
>
> Ok, committed.

Thanks Heikki.

--
Thom


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Slow temporary tables when using sync rep
Next
From: Alvaro Herrera
Date:
Subject: libpq URI and regression testing