Re: Postgres Replaying WAL slowly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres Replaying WAL slowly
Дата
Msg-id 19807.1404328492@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres Replaying WAL slowly  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-performance
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-07-01 15:20:37 -0400, Tom Lane wrote:
>> It seems like there are three, not mutually exclusive, ways we might
>> address this:

> But I think more importantly it's probably quite possible to hit a
> similar problem without ON COMMIT DROP relations. Say DISCARD TEMP
> inside a transaction (with several subxacts) or so? So we probaly really
> should fix the bad scaling.

Well, my thought was that these approaches would address somewhat
different sets of use-cases, and we might well want to do more than one.
Even if StandbyReleaseLocks were zero-cost, not emitting the WAL in the
first place is surely considerably cheaper yet.

            regards, tom lane


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Postgres Replaying WAL slowly
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Postgres Replaying WAL slowly