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.
I run that automaticly in the background or manually in a psql session or
via pgAdmin. Everywhere the same.
Then I run a "vacuum analysze verbose" and then I see the verbose output for
the analyze and of course the vacuum. And now the last_analyze column in
pg_statistics is updated.
So what's problem here? Why is this analyze only apppearing to run, but
Our postgres is 8.3 64 bit in solaris x86.
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2009-06-29 14:29:34|
|Subject: Re: analyze anomalie |
|Previous:||From: Brian Modra||Date: 2009-06-29 08:01:53|
|Subject: large cache|