performance_report_run4.html

text/html

Filename: performance_report_run4.html
Type: text/html
Part: 4
Message: Re: Adding basic NUMA awareness
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Performance Evaluation Matrix</title>
    <style>
        body { font-family: 'Segoe UI', Arial, sans-serif; margin: 40px; color: #333; background-color: #fafafa; }
        h2 { color: #2c3e50; border-bottom: 2px solid #bdc3c7; padding-bottom: 10px; margin-top: 0; }
        .table-container { background: #fff; padding: 25px; border-radius: 6px; box-shadow: 0 2px 4px rgba(0,0,0,0.06); margin-bottom: 45px; }
        p { color: #7f8c8d; font-size: 14px; margin-top: -5px; margin-bottom: 20px; }
    </style>
</head>
<body>
    <div class="table-container">
        <h2>Table 1: Performance Relative to Master Default (100% Baseline)</h2>
        <p>Values within ±2% of the baseline are considered noise and are uncolored.</p>
        <table border="1" style="border-collapse: collapse; text-align: center; font-family: Arial, sans-serif; width: 100%; border: 1px solid #ddd;">
  <tr style="background-color: #f2f2f2; border-bottom: 2px solid #ddd;">
    <th style="padding: 12px 10px; font-size: 13px;">Benchmark</th>
    <th style="padding: 12px 10px; font-size: 13px;">Clients</th>
    <th style="padding: 12px 10px; font-size: 12px;">master default (Baseline)</th>
    <th style="padding: 12px 10px; font-size: 12px;">master interleave</th>
    <th style="padding: 12px 10px; font-size: 12px;">optimized (numa=off, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">optimized (numa=on, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">optimized (numa=on, bal=on)</th>
    <th style="padding: 12px 10px; font-size: 12px;">patched (numa=off, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">patched (numa=on, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">patched (numa=on, bal=on)</th>
  </tr>
  <tr style="border-bottom: 1px solid #eee;">
    <td style="padding: 10px 8px; font-weight: bold; text-align: left; font-size: 13px; background-color: #fafafa;">pgbenchS100krows</td>
    <td style="padding: 10px 8px; font-weight: bold; font-size: 13px; background-color: #fafafa;">1</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.00%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">91.38%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">93.38%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">98.57%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">94.32%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">81.72%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">84.25%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #f5c6cb; color: #721c24; font-weight: bold;">76.65%</td>
  </tr>
  <tr style="border-bottom: 1px solid #eee;">
    <td style="padding: 10px 8px; font-weight: bold; text-align: left; font-size: 13px; background-color: #fafafa;">pgbenchS100krows</td>
    <td style="padding: 10px 8px; font-weight: bold; font-size: 13px; background-color: #fafafa;">8</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.00%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.98%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.79%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.75%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #c3e6cb; color: #155724; font-weight: bold;">102.13%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #f5c6cb; color: #721c24; font-weight: bold;">87.25%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">87.75%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">87.32%</td>
  </tr>
  <tr style="border-bottom: 1px solid #eee;">
    <td style="padding: 10px 8px; font-weight: bold; text-align: left; font-size: 13px; background-color: #fafafa;">pgbenchS100krows</td>
    <td style="padding: 10px 8px; font-weight: bold; font-size: 13px; background-color: #fafafa;">32</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.00%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.79%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">101.87%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #28a745; font-weight: 500;">103.10%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #c3e6cb; color: #155724; font-weight: bold;">103.76%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #f5c6cb; color: #721c24; font-weight: bold;">90.77%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">92.42%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">92.02%</td>
  </tr>
</table>
    </div>
    
    <div class="table-container">
        <h2>Table 2: Performance Relative to Master Interleave (100% Baseline)</h2>
        <p>Values within ±2% of the baseline are considered noise and are uncolored.</p>
        <table border="1" style="border-collapse: collapse; text-align: center; font-family: Arial, sans-serif; width: 100%; border: 1px solid #ddd;">
  <tr style="background-color: #f2f2f2; border-bottom: 2px solid #ddd;">
    <th style="padding: 12px 10px; font-size: 13px;">Benchmark</th>
    <th style="padding: 12px 10px; font-size: 13px;">Clients</th>
    <th style="padding: 12px 10px; font-size: 12px;">master interleave (Baseline)</th>
    <th style="padding: 12px 10px; font-size: 12px;">master default</th>
    <th style="padding: 12px 10px; font-size: 12px;">optimized (numa=off, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">optimized (numa=on, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">optimized (numa=on, bal=on)</th>
    <th style="padding: 12px 10px; font-size: 12px;">patched (numa=off, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">patched (numa=on, bal=off)</th>
    <th style="padding: 12px 10px; font-size: 12px;">patched (numa=on, bal=on)</th>
  </tr>
  <tr style="border-bottom: 1px solid #eee;">
    <td style="padding: 10px 8px; font-weight: bold; text-align: left; font-size: 13px; background-color: #fafafa;">pgbenchS100krows</td>
    <td style="padding: 10px 8px; font-weight: bold; font-size: 13px; background-color: #fafafa;">1</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.00%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #c3e6cb; color: #155724; font-weight: bold;">109.43%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #28a745; font-weight: 500;">102.18%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #28a745; font-weight: 500;">107.86%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #28a745; font-weight: 500;">103.22%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">89.43%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">92.19%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #f5c6cb; color: #721c24; font-weight: bold;">83.87%</td>
  </tr>
  <tr style="border-bottom: 1px solid #eee;">
    <td style="padding: 10px 8px; font-weight: bold; text-align: left; font-size: 13px; background-color: #fafafa;">pgbenchS100krows</td>
    <td style="padding: 10px 8px; font-weight: bold; font-size: 13px; background-color: #fafafa;">8</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.00%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">99.03%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">99.80%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">99.77%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">101.14%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #f5c6cb; color: #721c24; font-weight: bold;">86.40%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">86.90%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">86.47%</td>
  </tr>
  <tr style="border-bottom: 1px solid #eee;">
    <td style="padding: 10px 8px; font-weight: bold; text-align: left; font-size: 13px; background-color: #fafafa;">pgbenchS100krows</td>
    <td style="padding: 10px 8px; font-weight: bold; font-size: 13px; background-color: #fafafa;">32</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">100.00%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">99.22%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #7f8c8d;">101.07%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #28a745; font-weight: 500;">102.30%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #c3e6cb; color: #155724; font-weight: bold;">102.95%</td>
    <td style="padding: 10px 8px; font-size: 13px; background-color: #f5c6cb; color: #721c24; font-weight: bold;">90.06%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">91.69%</td>
    <td style="padding: 10px 8px; font-size: 13px; color: #dc3545; font-weight: 500;">91.30%</td>
  </tr>
</table>
    </div>
</body>
</html>