Michael Paesold wrote:
Matthew T. O'Connor wrote:
Two questions: 1) It is my understanding that these new GUC vars only effect vacuum. That is they do NOT have any effect on an analyze command right? (I ask since I'm only setting the vars before I issue a vacuum command)
No, vacuum also affects analyze alone (cvs tip here): (2.5 seconds -> 50 seconds)
[snip examples...]
I suggest you also issue the SET commands for analyze also. ISTM that there is also no distinction between VACUUM and VACUUM FULL, but I think pg_autovacuum never does a vacuum full, so there is no problem with that.
Ok, I'll do that too.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
