[GENERAL] Analyze Explanation

2008-01-29 Thread Willem Buitendyk 
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?


---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Analyze Explanation

2008-01-29 Thread Tom Lane 
Willem Buitendyk <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Analyze Explanation

2008-01-29 Thread Michael Fuhr 
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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings