Re: Analyze Explanation

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Willem Buitendyk <willem(at)pcfish(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Analyze Explanation
Date: 2008-01-29 19:48:52
Message-ID: 20080129194852.GA93163@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 29, 2008 at 10:11:38AM -0800, Willem Buitendyk wrote:
> When I run Analyze I get the following notice repeated for many of my
> tables:
>
> NOTICE: no notnull values, invalid stats
>
> Is this just refering to my empty tables?

The PostGIS function compute_geometry_stats() logs such a message.
I'd guess you're using PostGIS and those tables have NULL in all
rows' geometry columns.

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2008-01-29 20:16:41 Re: OT - pg perl DBI question
Previous Message Tom Lane 2008-01-29 19:47:11 Re: Table has duplicate keys, what did I do