Analyze Explanation

Lists: pgsql-general
From: Willem Buitendyk <willem(at)pcfish(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Analyze Explanation
Date: 2008-01-29 18:11:38
Message-ID: 479F6C5A.7080108@pcfish.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Willem Buitendyk <willem(at)pcfish(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Analyze Explanation
Date: 2008-01-29 19:43:41
Message-ID: 24621.1201635821@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Willem Buitendyk <willem(at)pcfish(dot)ca> writes:
> When I run Analyze I get the following notice repeated for many of my
> tables:
> NOTICE: no notnull values, invalid stats

There's no such message in the core Postgres code. Perhaps it's coming
from an add-on, such as Postgis? If so, you should ping them about why
they think this notice is needed.

regards, tom lane

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
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