Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow temporary tables when using sync rep - Mailing list pgsql-hackers

From Michael Nolan
Subject Re: Slow temporary tables when using sync rep
Date
Msg-id CAOzAqu+vVbNHcg8C8Q5PnXcqTyxhTcJGP3usJ5ZBxr+epPzMLQ@mail.gmail.com
Whole thread Raw
In response to Slow temporary tables when using sync rep  (Thom Brown <thom@linux.com>)
Responses Re: Slow temporary tables when using sync rep  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Tree view


On Mon, Apr 16, 2012 at 6:27 PM, Thom Brown <thom@linux.com> wrote:
Hi,

I've noticed that when using synchronous replication (on 9.2devel at
least), temporary tables become really slow:

Since temporary tables are only present until the session ends (or possibly only until a commit), why are they replicated at all?

BTW,  should we have an entry in the index for 'temporary tables?
--
Mike Nolan

pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Slow temporary tables when using sync rep
Next
From: Amit Kapila
Date:
Subject: Re: Improving our clauseless-join heuristics