analyze anomalie

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux