Thread: Analyze Explanation
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?
Willem Buitendyk <willem@pcfish.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
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