Skip site navigation (1) Skip section navigation (2)

Re: pg_statistic, lack of documentation

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_statistic, lack of documentation
Date: 2012-01-27 17:14:38
Message-ID: CA+TgmoYGvM1sTDx1+MYuwZEeG4J969OeMg-V=i9uXehVvUUrRQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, Jan 14, 2012 at 7:34 AM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> wrote:
> Hi,
>
> http://www.postgresql.org/docs/9.1/interactive/catalog-pg-statistic.html
>
> It specifies that entries are created by ANALYZE, but does not mention
> that if a table is empty the entry for it is not created.

The actual behavior, in somewhat more detail, is that the existing
statistics entries, if any, are retained.

I've added a note to that effect to the documentation for ANALYZE,
which seems like a more appropriate place than the pg_statistic
documentation.

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

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-01-27 17:16:51
Subject: Re: patch for parallel pg_dump
Previous:From: karavelovDate: 2012-01-27 17:01:59
Subject: Re: TS: Limited cover density ranking

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group