Horton

Re: Slow temporary tables when using sync rep

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Thom Brown <thom@linux.com>
Cc: Michael Nolan <htfoot@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-04-17T13:35:00Z
Lists: pgsql-hackers 
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.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com