Re: Slow temporary tables when using sync rep

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Re: Slow temporary tables when using sync rep
Дата
Msg-id CAOzAqu+vVbNHcg8C8Q5PnXcqTyxhTcJGP3usJ5ZBxr+epPzMLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Slow temporary tables when using sync rep  (Thom Brown <thom@linux.com>)
Ответы Re: Slow temporary tables when using sync rep  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Slow temporary tables when using sync rep
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Improving our clauseless-join heuristics