Hi,

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
doesn't?

Our postgres is 8.3 64 bit in solaris x86.

best regards,
Uwe

Reply via email to