Re: Regress tests to improve the function coverage of schemacmds and user and tablespace files

<div class="WordSection1"><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New
Roman","serif";color:windowtext">On</span><span style="font-size:12.0pt;font-family:"Times New
Roman","serif";color:windowtext">24November 2013 03:04 David Rowley wrote:</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif";color:windowtext"> </span><p class="MsoNormal"><span
style="color:windowtext">>I'vedone a quick benchmark on this this morning.</span><p class="MsoNormal"><span
style="color:windowtext">>Notethat I'm using windows here and I used powershell to time the regression run with the
followingcommand:</span><p class="MsoNormal"><span style="color:windowtext">> </span><p class="MsoNormal"><span
style="color:windowtext">>PSD:\Postgres\b\src\tools\msvc> Measure-Command { .\vcregress.bat check }</span><p
class="MsoNormal"><spanstyle="color:windowtext">> </span><p class="MsoNormal"><span style="color:windowtext">>I
ranthe tests 10 times each.</span><p class="MsoNormal"><span style="color:windowtext">>I ran the patched version
first,then just did git reset --hard to revert the patched changes then I ran the tests again.</span><p
class="MsoNormal"><spanstyle="color:windowtext">> </span><p class="MsoNormal"><span style="color:windowtext">>The
averageand median results over the 10 runs are as follows:</span><p class="MsoNormal"><span
style="color:windowtext">> </span><pclass="MsoNormal"><span style="color:windowtext">>            
Patched              Unpatched         Time increased by</span><p class="MsoNormal"><span
style="color:windowtext">>Average           48.23265888       47.70979854       101.10%</span><p
class="MsoNormal"><spanstyle="color:windowtext">>Median              47.8993686          47.51177815      
100.82%</span><pclass="MsoNormal"><span style="color:windowtext">> </span><p class="MsoNormal"><span
style="color:windowtext">> </span><pclass="MsoNormal"><span style="color:windowtext">>The slowdown is not too
bad.It just around 1% increase of time.</span><p class="MsoNormal"><span style="color:windowtext">> </span><p
class="MsoNormal"><spanstyle="color:windowtext">>I've attached the results in spreadsheet format.</span><p
class="MsoNormal"><spanstyle="color:windowtext"> </span><p class="MsoNormal"><span style="color:windowtext">Thanks  for
thereview and benchmark test.</span><p class="MsoNormal"><span style="color:windowtext"> </span><p
class="MsoNormal"><spanstyle="color:windowtext">Regards,</span><p class="MsoNormal"><span style="color:windowtext">Hari
babu.</span><pclass="MsoNormal"><span style="color:windowtext"> </span><p class="MsoNormal"><span
style="color:windowtext"> </span></div>