Re: [HACKERS] shared memory based stat collector (was: Sharing recordtypmods between backends) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] shared memory based stat collector (was: Sharing recordtypmods between backends)
Date
Msg-id CA+TgmoZbd+PyAaRpca9RbTB6WiHr6OaA3P1ygqPoSek73VJZ9g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)  (Andres Freund <andres@anarazel.de>)
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] shared memory based stat collector (was: Sharingrecord typmods between backends)