Skip site navigation (1) Skip section navigation (2)

Re: Slow temporary tables when using sync rep

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Thom Brown <thom(at)linux(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:35:00
Message-ID: 4F8D7184.8050705@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

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

In response to

Responses

pgsql-hackers by date

Next:From: Thom BrownDate: 2012-04-17 13:44:50
Subject: Re: Slow temporary tables when using sync rep
Previous:From: Alex ShulginDate: 2012-04-17 13:29:30
Subject: Re: Bug tracker tool we need

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group