Re: Slow temporary tables when using sync rep

Michael Nolan <htfoot@gmail.com>

From: Michael Nolan <htfoot@gmail.com>

To: Thom Brown <thom@linux.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2012-04-16T23:54:30Z

Lists: pgsql-hackers

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