Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

Поиск
Список
Период
Сортировка
От Dilip kumar
Тема Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]
Дата
Msg-id 4205E661176A124FAF891E0A6BA913526636F1D7@szxeml509-mbs.china.huawei.com
обсуждение исходный текст
Ответ на Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
<div class="WordSection1"><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">On</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"></span><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">13November 2014 15:35 Amit Kapila Wrote, </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span><p class="MsoNormal">>As
mentionedby you offlist that you are not able reproduce this<p class="MsoNormal">>issue, I have tried again and what
Iobserve is that I am able to<p class="MsoNormal">>reproduce it only on *release* build and some cases work
without<pclass="MsoNormal">>this issue as well,<p class="MsoNormal">>example:<p class="MsoNormal">>./vacuumdb
--analyze-in-stages-t t1 -t t2 -t t3 -t t4 -t t5 -t t6 -t t7 -t t8 -j 8 -d postgres<p class="MsoNormal">>Generating
minimaloptimizer statistics (1 target)<p class="MsoNormal">>Generating medium optimizer statistics (10 targets)<p
class="MsoNormal">>Generatingdefault (full) optimizer statistics<p class="MsoNormal"><br clear="all" /><p
class="MsoNormal">>Soto me, it looks like this is a timing issue and please notice<p class="MsoNormal">>why in
errorthe statement looks like<p class="MsoNormal">>"ANALYZE ng minimal optimizer statistics (1 target)".  I think
this<pclass="MsoNormal" style="margin-bottom:12.0pt">>is not a valid statement.<p class="MsoNormal">>Let me know
ifyou still could not reproduce it.<p class="MsoNormal"> <p class="MsoNormal">Thank you for looking into it once
again..<pclass="MsoNormal"> <p class="MsoNormal">I have tried with the release mode, but could not reproduce the same.
Bylooking at server LOG sent by you “"ANALYZE ng minimal optimizer statistics (1 target)". ”, seems like some
corruption.<pclass="MsoNormal"> <p class="MsoNormal">So actually looks like two issues here.<p class="MsoListParagraph"
style="text-indent:-18.0pt;mso-list:l0level1 lfo1"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New
Roman"">     </span></span>Query string sent to server is getting corrupted.<p class="MsoListParagraph"
style="text-indent:-18.0pt;mso-list:l0level1 lfo1"><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New
Roman"">     </span></span>Client is getting crashed.<p class="MsoNormal"> <p class="MsoNormal">I will review the code
andtry to find the same, meanwhile if you can find some time to debug this, it will be really helpful.<p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">Regards,<p class="MsoNormal">Dilip</div> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: PostgreSQL doesn't stop propley when --slot option is specified with pg_receivexlog.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: PostgreSQL doesn't stop propley when --slot option is specified with pg_receivexlog.