Re: pg_stat_*_columns? - Mailing list pgsql-hackers

From Andres Freund
Subject Re: pg_stat_*_columns?
Date
Msg-id 20150624084343.GC23915@awork2.anarazel.de
Whole thread Raw
In response to Re: pg_stat_*_columns?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2015-06-23 16:32:54 -0400, Robert Haas wrote:
> On Tue, Jun 23, 2015 at 3:47 PM, Andres Freund <andres@anarazel.de> wrote:
> > On 2015-06-22 21:05:52 -0400, Robert Haas wrote:
> >> Interesting idea.  We could consider the set of stats files a database
> >> unto itself and reserve a low-numbered OID for it.  The obvious thing
> >> to do is use the database's OID as the relfilenode, but then how do
> >> you replace the stats file?
> >
> > The relmapper infrastructure should be able to take care of that.
> 
> How?  I think it assumes that the number of mapped entries is pretty small.

Well, we could just use one stats file for all of the stats - that'd not
necessarily be bad. The relmapper would just be there to be able, if we
need it, to rewrite them in the background. The other alternative is to
place the stats file in the target database instead of pg_global, in
which case we can just use the per database relmapper.

Andres



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Hash index creation warning
Next
From: Craig Ringer
Date:
Subject: Re: Hash index creation warning