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 suc

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 p

[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