Re: Online index builds
От | Joshua D. Drake |
---|---|
Тема | Re: Online index builds |
Дата | |
Msg-id | 44B99876.3060604@commandprompt.com обсуждение исходный текст |
Ответ на | Re: Online index builds (Greg Stark <gsstark@mit.edu>) |
Ответы |
Re: Online index builds
|
Список | pgsql-hackers |
> That said I'm not sure how much I can do here. For a substantial index we > should expect most of the time will be spent in the tuplesort. It's hard to > see how to get any sort of progress indicator out of there and as long as we > can't it's hard to see the point of getting one during the heap scan or any of > the other i/o operations. Well from a DBA perspective, just knowing that "something" productive is happening is useful. When using vacuum I almost always use vacuum verbose, just so I have an idea of what is going on. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutionssince 1997 http://www.commandprompt.com/
В списке pgsql-hackers по дате отправления: