On Wed, Dec 23, 2015 at 2:07 PM, Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> The remaining question is how unique the statistics name should be.
> My initial plan was to make it unique within a table, but that of
> course does not work well with the DROP STATISTICS (it'd have to
> specify the table name also), and it'd also now work with statistics
> on multiple tables (which is one of the reasons for abandoning ALTER
> TABLE stuff).
>
> So I think it should be unique across tables. Statistics are hardly
> a global object, so it should be unique within a schema. I thought
> that simply using the schema of the table would work, but that of
> course breaks with multiple tables in different schemas. So the only
> solution seems to be explicit schema for statistics.
That solution seems good to me.
(with apologies for not having looked at the rest of this much at all)
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company