Re: Analyze Explanation - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Analyze Explanation
Date
Msg-id 20080129194852.GA93163@winnie.fuhr.org
Whole thread Raw
In response to Analyze Explanation  (Willem Buitendyk <willem@pcfish.ca>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Analyze Explanation
Next
From: "A.M."
Date:
Subject: Re: OT - pg perl DBI question