Re: Is analyze_new_cluster.sh still useful?
От | Tom Lane |
---|---|
Тема | Re: Is analyze_new_cluster.sh still useful? |
Дата | |
Msg-id | 23528.1403112254@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Is analyze_new_cluster.sh still useful? (Andres Freund <andres@2ndquadrant.com>) |
Ответы |
Re: Is analyze_new_cluster.sh still useful?
|
Список | pgsql-hackers |
Andres Freund <andres@2ndquadrant.com> writes: > On 2014-06-18 12:51:43 -0400, Tom Lane wrote: >> Another angle is that some folks might have tried to automate things >> even more, with a wrapper script that starts up the new postmaster >> and runs analyze_new_cluster.sh all by itself. I guess they could >> make the wrapper do "vacuumdb --all --analyze-in-stages" directly, >> though, so maybe that's not a fatal objection either. > Wouldn't that be quite counterproductive? The reason we don't normally > do that and why --analyze-in-stages exists is that the cluster should be > started up as fast as possible. Restarting it after ANALYZE went through > would be defeating that purpose, no? How so? Once you've started the postmaster, you're open for business, no? regards, tom lane
В списке pgsql-hackers по дате отправления: