<div id="readability-page-1" class="page"><div>
  <main>
    <h3 id="intro">Intro</h3>
<hr>
<ul>
<li>
<p>I worked with PostgreSQL project in Google Summer of Code 2022 this summer.</p>
</li>
<li>
<p>I tried to improve test coverage for various modules.</p>
</li>
</ul>
<h3 id="goal">Goal</h3>
<hr>
<ul>
<li>
<p>My Goal is to improve the test coverage of PostgreSQL, as indicated in the <a href="https://wiki.postgresql.org/wiki/GSoC_2022#Improve_PostgreSQL_Regression_Test_Coverage_(2022)">postgres wiki - gsoc 2022</a> document.</p>
</li>
<li>
<p>Here is my Proposal <a href="https://dl.dropbox.com/s/mgop5q1mycvpl0a/gAAAAABjErgY_7TGz_qtSy2lceFAH09AtKxa_dh0NelFvmxO0a14dV5ExNZgIwYxzW-NCryXgYs4Z5RV1iLsPzSKaCKXg2HKqr6g28fz4E5WERJXjMCE-a0%3D.pdf">Improve PostgreSQL Regression Test Coverage - DongWook Lee</a></p>
</li>
<li>
<p>My original goal was to increase the test coverage of the modules below.</p>
</li>
</ul>
<pre tabindex="0"><code>- pg_dump
- psql
- pg_ctl
- initdb
- pg_stat_statments
- pg_buffercache
- pg_prewarm
- pgrowlocks
- pgstattuple
- pg_waldump
- pg_basebackup
</code></pre><ul>
<li>Except for <code>pg_dump</code>, <code>pg_ctl</code>, <code>initdb</code>, and <code>pg_stat_statments</code>, I attempted all to improve test coverage, and several succeeded.</li>
</ul>
<h3 id="coverage-result">Coverage Result</h3>
<hr>
<h4 id="pgrowlocks">pgrowlocks</h4>
<p><strong>Before</strong>
<img src="https://dl.dropbox.com/s/jg9tpvnnzmm43tu/Screen%20Shot%202022-09-03%20at%2012.15.18%20PM.png" alt="before">
<strong>After</strong>
<img src="https://dl.dropbox.com/s/kz1j469zxynmfvc/Screen%20Shot%202022-09-03%20at%2012.17.15%20PM.png" alt="after"></p>
<ul>
<li>Improve coverage <code>0%</code> to <code>90.7%</code></li>
</ul>
<h4 id="pg_prewram">pg_prewram</h4>
<p><strong>Before</strong>
<img src="https://dl.dropbox.com/s/99tslxr4yq9q1ly/Screen%20Shot%202022-09-03%20at%2012.19.13%20PM.png" alt="before">
<strong>After</strong>
<img src="https://dl.dropbox.com/s/dajhpb9cllffaeh/Screen%20Shot%202022-09-03%20at%2012.19.31%20PM.png" alt="after"></p>
<ul>
<li>Improve coverage <code>11.6%</code> to <code>77.3%</code></li>
</ul>
<h4 id="pg_buffercache">pg_buffercache</h4>
<p><strong>Before</strong>
<img src="https://dl.dropbox.com/s/1z04900ai33x0nl/Screen%20Shot%202022-09-03%20at%2012.25.48%20PM.png" alt="before">
<strong>After</strong>
<img src="https://dl.dropbox.com/s/2df9i1vuft59mfo/Screen%20Shot%202022-09-03%20at%2012.26.01%20PM.png" alt="after"></p>
<ul>
<li>Improve coverage <code>0%</code> to <code>97.6%</code></li>
</ul>
<h3 id="commitfest">Commitfest</h3>
<hr>
<ul>
<li><a href="https://commitfest.postgresql.org/38/3732/">pg_prewarm add configuration example</a></li>
<li><a href="https://commitfest.postgresql.org/38/3674/">pg_buffercache: add sql test</a></li>
<li><a href="https://commitfest.postgresql.org/38/3723/">Add test of pg_prewarm extension</a></li>
<li><a href="https://commitfest.postgresql.org/38/3677/">Add TAP test for auth_delay extension</a></li>
<li><a href="https://commitfest.postgresql.org/39/3805/">old_snapshot: add test for coverage</a></li>
<li><a href="https://commitfest.postgresql.org/39/3834/">pg_waldump: add test for coverage</a></li>
<li><a href="https://commitfest.postgresql.org/39/3835/">pg_basebackup: add test about zstd compress option</a></li>
<li><a href="https://commitfest.postgresql.org/39/3793/">pgstattuple: add test for coverage</a></li>
<li><a href="https://commitfest.postgresql.org/39/3833/">xml2: add test for coverage</a></li>
<li><a href="https://commitfest.postgresql.org/39/3852/">pg_checksum: add test for coverage</a></li>
<li><a href="https://commitfest.postgresql.org/39/3724/">add test: pg_rowlocks extension</a></li>
<li><a href="https://commitfest.postgresql.org/40/3877/">vacuumlo: add test to vacuumlo for test coverage</a></li>
</ul>
<h3 id="patch-series">Patch Series</h3>
<hr>
<ul>
<li><a href="https://github.com/postgres/postgres/commit/90247e742f849794d061a0444071647728054b45">Add a regression test for contrib/pgrowlocks</a></li>
<li><a href="https://github.com/postgres/postgres/commit/2865b4060a434855f90fda41f1b8f4bca7c55b0e">Add a regression test for contrib/pg_prewarm</a></li>
<li><a href="https://github.com/postgres/postgres/commit/be39d88934331c47c43d8c51500305e928f06240">Add regression test coverage for contrib/pg_buffercache</a></li>
<li><a href="https://github.com/postgres/postgres/commit/aa31b29375b9afbe1330d7726855645ff82a2e51">doc: add pg_prewarm example</a></li>
</ul>

    <a href="../../../../"> &gt;&gt; Home</a>
  </main>
</div></div>

Home on 개발자 이동욱

Lee Dong Wook

Intro
I worked with PostgreSQL project in Google Summer of Code 2022 this summer.
I tried to improve test coverage for various modules.
Goal
My Goal is to improve the test coverage of PostgreSQL, as indicated in the postgres wiki - gsoc 2022 document.
Here is my Proposal Improve PostgreSQL Regression Test Coverage - DongWook Lee
My original goal was to increase the test coverage of the modules below.
- pg_dump
- psql
- pg_ctl
- initdb
- pg_stat_statments
- pg_buffercache
- pg_prewarm
- pgrowlocks
- pgstattuple
- pg_waldump
- pg_basebackup
Except for pg_dump, pg_ctl, initdb, and pg_stat_statments, I attempted all to improve test coverage, and several succeeded.
Coverage Result
pgrowlocks
Before
After
Improve coverage 0% to 90.7%
pg_prewram
Before
After
Improve coverage 11.6% to 77.3%
pg_buffercache
Before
After
Improve coverage 0% to 97.6%
Commitfest
pg_prewarm add configuration example
pg_buffercache: add sql test
Add test of pg_prewarm extension
Add TAP test for auth_delay extension
old_snapshot: add test for coverage
pg_waldump: add test for coverage
pg_basebackup: add test about zstd compress option
pgstattuple: add test for coverage
xml2: add test for coverage
pg_checksum: add test for coverage
add test: pg_rowlocks extension
vacuumlo: add test to vacuumlo for test coverage
Patch Series
Add a regression test for contrib/pgrowlocks
Add a regression test for contrib/pg_prewarm
Add regression test coverage for contrib/pg_buffercache
doc: add pg_prewarm example

GSoC 2022 Final Report - PostgreSQL

댓글