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

From Robert Haas
Subject Re: pg_stat_*_columns?
Date
Msg-id CA+TgmoY+_XNVovVNK=vPAXQTdnjqxA1PxzwKWUzkXBhy90cRGg@mail.gmail.com
Whole thread Raw
In response to pg_stat_*_columns?  (Joel Jacobson <joel@trustly.com>)
Responses Re: pg_stat_*_columns?  (Joel Jacobson <joel@trustly.com>)
List pgsql-hackers
On Fri, Jun 5, 2015 at 7:51 AM, Joel Jacobson <joel@trustly.com> wrote:
> Would others find it useful to see per column statistics about accesses to
> specific columns?

A probably serious and maybe not entirely obvious problem with this is
that it would increase the amount of statistical information we keep
by a pretty large multiple.  How many columns do you have in a typical
table?  20-30?  That's a lot of data for a statistics collector that,
regrettably, is already overloaded.

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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [CORE] Restore-reliability mode
Next
From: Alvaro Herrera
Date:
Subject: Re: [CORE] back-branch multixact fixes & 9.5 alpha/beta: schedule