Re: [HACKERS] shared memory based stat collector (was: Sharing recordtypmods between backends)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] shared memory based stat collector (was: Sharing recordtypmods between backends)
Дата
Msg-id CA+TgmoZbd+PyAaRpca9RbTB6WiHr6OaA3P1ygqPoSek73VJZ9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Mon, Aug 14, 2017 at 1:02 PM, Andres Freund <andres@anarazel.de> wrote:
> I previously thought that an option to occasionally WAL log the stats
> file would be useful (e.g. just before a checkpoint). That'd make them
> persistent, and available on the standby. But that'd still require
> somehow dealing with stats being produced on the standby - I presume
> we'd need multiple stats files and provide functions for merging them.

Well, if you think the stats files might be too big to fit in memory,
then you're probably imagining tens of gigabytes of data, and you're
not going to want to write a WAL record that size, either.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)