Larry Rosenman wrote:
Alvaro Herrera wrote:
Bruce Momjian wrote:
Well, the problem is that it shows what it's *currently* doing, but it
doesn't let you know what has happened in the last day or whatever.
It can't answer "has table foo been vacuumed recently?" or "what
tables haven't been vacuumed at all during this week?"
I added last vacuum and last analyze (both auto and manual) dates in the 8.2
tree.....
Hmm... well that does address most of my issue. Doesn't tell me that
table_foo is getting vacuumed constantly, but it does tell me that it
was vacuumed recently. Might be good enough.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
