Hi Tom, I was running the command as user postgres (default). The "vacuum anlyze" and the "analyze" I run as the same user. client_min_messages is still set to default in the server config.
reagrds, Uwe 2009/6/29 Tom Lane <[email protected]> > Uwe Bartels <[email protected]> writes: > > today i found an anomalie running > > analyze verbose <table> > > > the output was simply "ANALYZE", which tells me that analyze was running > > successfully. but there was no verbose output. and in the statistics > table > > was no updated last_analyze column. > > Perhaps you didn't have permission to analyze the table, and had > client_min_messages set too high to see the resulting WARNING? > It would have done something like this: > > regression=> analyze verbose tenk1; > WARNING: skipping "tenk1" --- only table or database owner can analyze it > ANALYZE > > but if the WARNING got suppressed it would match what you stated. > > regards, tom lane >
