Re: Slow temporary tables when using sync rep

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 11:10:01
Message-ID: CAA-aLv480iRHOe71bATkf4YDuMjetWwf09dJKYmZQucgswt=jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Thom

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Qi Huang 2012-04-17 11:55:36 Re: Gsoc2012 idea, tablesample
Previous Message Kyotaro HORIGUCHI 2012-04-17 11:08:52 Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments