From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | Michael Nolan <htfoot(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Slow temporary tables when using sync rep |
Date: | 2012-04-17 13:44:50 |
Message-ID: | CAA-aLv6wSAQ6RFUDpE-5n51JP0f2iwPnSN4byz1H-DnA-ivgWA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 17 April 2012 14:35, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> On 17.04.2012 14:10, Thom Brown wrote:
>>
>> On 17 April 2012 11:30, Heikki Linnakangas
>> <heikki(dot)linnakangas(at)enterprisedb(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2012-04-17 13:47:26 | libpq URI and regression testing |
Previous Message | Heikki Linnakangas | 2012-04-17 13:35:00 | Re: Slow temporary tables when using sync rep |