| From: | Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | analyze anomalie |
| Date: | 2009-06-29 08:40:24 |
| Message-ID: | 8ea917510906290140vf3f6651m382c84a29c25fb41@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-06-29 14:29:34 | Re: analyze anomalie |
| Previous Message | Brian Modra | 2009-06-29 08:01:53 | large cache |