Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

analyze anomalie



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


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group