Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ] - Mailing list pgsql-hackers

From Dilip kumar
Subject Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]
Date
Msg-id 4205E661176A124FAF891E0A6BA913526636F1D7@szxeml509-mbs.china.huawei.com
Whole thread Raw
In response to Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Amit Kapila <amit.kapila16@gmail.com>)
List 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 by date:

Previous
From: Fujii Masao
Date:
Subject: Re: PostgreSQL doesn't stop propley when --slot option is specified with pg_receivexlog.
Next
From: Michael Paquier
Date:
Subject: Re: PostgreSQL doesn't stop propley when --slot option is specified with pg_receivexlog.