| 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: | Whole Thread | Raw Message | 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 |