[GENERAL] 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? ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Analyze Explanation
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
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