Re: [HACKERS] POC: Sharing record typmods between backends - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] POC: Sharing record typmods between backends
Date
Msg-id CA+TgmobX6ziAzK=LhZmce0nBD2_XQU-hWQaGRa4fgf15Hdek=w@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] POC: Sharing record typmods between backends  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] POC: Sharing record typmods between backends  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, Aug 12, 2017 at 11:30 PM, Andres Freund <andres@anarazel.de> wrote:
> That seems to involve a lot more than this though, given that currently
> the stats collector data doesn't entirely have to be in memory. I've
> seen sites with a lot of databases with quite some per-database stats
> data. Don't think we can just require that to be in memory :(

Hmm.  I'm not sure it wouldn't end up being *less* memory.  Don't we
end up caching 1 copy of it per backend, at least for the database to
which that backend is connected?  Accessing a shared copy would avoid
that sort of thing.

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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] POC: Sharing record typmods between backends
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] POC: Sharing record typmods between backends