• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

pgconfig / api
37%
master: 79%

Build:
Build:
LAST BUILD BRANCH: dependabot/github_actions/actions/setup-go-6
DEFAULT BRANCH: master
Repo Added 01 Nov 2021 10:59PM UTC
Files 37
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

LAST BUILD ON BRANCH seba/update-param-short-desc
branch: seba/update-param-short-desc
CHANGE BRANCH
x
Reset
  • seba/update-param-short-desc
  • dependabot/github_actions/actions/checkout-5
  • dependabot/github_actions/actions/checkout-6
  • dependabot/github_actions/actions/download-artifact-7
  • dependabot/github_actions/actions/setup-go-4
  • dependabot/github_actions/actions/setup-go-5
  • dependabot/github_actions/actions/setup-go-6
  • dependabot/github_actions/actions/upload-artifact-6
  • dependabot/github_actions/goreleaser/goreleaser-action-6
  • main
  • master
  • refs/tags/0.3.1
  • refs/tags/3.0.0
  • refs/tags/3.0.0-beta1
  • refs/tags/3.0.0-beta2
  • refs/tags/3.0.0-beta3
  • refs/tags/3.0.0-rc1
  • refs/tags/3.1.0
  • refs/tags/3.1.1
  • refs/tags/3.1.3
  • refs/tags/3.1.4
  • seba/fix-env-parse
  • seba/fix-goreleaser
  • seba/fix-goreleaser2
  • seba/fix-goreleaser3
  • seba/fixing-some-issues
  • seba/jsonlog
  • seba/pg18
  • seba/use-rspec-like-tests

05 Feb 2026 12:30AM UTC coverage: 36.842% (+5.7%) from 31.117%
21693893043

Pull #35

github

sebastianwebber
feat: make worker parameters dynamic based on CPU and profile

Scale worker parameters with CPU cores instead of using fixed values:
- max_worker_processes: minimum 8 or CPU count
- max_parallel_workers: minimum 8 or CPU count
- max_parallel_workers_per_gather: 2 for transactional workloads
  (Desktop/Web/Mixed/OLTP), CPU/2 for DW (analytical workloads)

Add comprehensive table-driven tests covering various CPU counts
and workload profiles.

Signed-off-by: Sebastian Webber <sebastian@swebber.me>
Pull Request #35: updating param desc

84 of 85 new or added lines in 3 files covered. (98.82%)

427 of 1159 relevant lines covered (36.84%)

8.35 hits per line

Relevant lines Covered
Build:
Build:
1159 RELEVANT LINES 427 COVERED LINES
8.35 HITS PER LINE
Source Files on seba/update-param-short-desc
  • Tree
  • List 36
  • Changed 5
  • Source Changed 0
  • Coverage Changed 5
Coverage ∆ File Lines Relevant Covered Missed Hits/Line

Recent builds

Builds Branch Commit Type Ran Committer Via Coverage
21693893043 seba/update-param-short-desc feat: make worker parameters dynamic based on CPU and profile Scale worker parameters with CPU cores instead of using fixed values: - max_worker_processes: minimum 8 or CPU count - max_parallel_workers: minimum 8 or CPU count - max_parallel_worke... Pull #35 05 Feb 2026 12:32AM UTC sebastianwebber github
36.84
21693672415 seba/update-param-short-desc docs: improve max_worker_processes documentation Explain worker pool concept and various consumers (parallel query, replication, extensions). Add recommendation to set based on CPU core count or at least 25% of vCPUs. Signed-off-by: Sebastian We... Pull #35 05 Feb 2026 12:22AM UTC sebastianwebber github
35.48
21692951299 seba/update-param-short-desc docs: improve io_workers documentation with sizing guidance Add workload-specific recommendations for worker count based on CPU cores (10-40%). Explain when higher values are beneficial and how to monitor for saturation. Signed-off-by: Sebastian... Pull #35 04 Feb 2026 11:53PM UTC sebastianwebber github
35.48
21692540478 seba/update-param-short-desc docs: improve effective_io_concurrency documentation Clarify that parameter only affects bitmap heap scans and add context about when bitmap scans are used. Include note about PostgreSQL 18 default change from 1 to 16. Signed-off-by: Sebastian W... Pull #35 04 Feb 2026 11:35PM UTC sebastianwebber github
35.48
21692241231 seba/update-param-short-desc feat: optimize random_page_cost for DW analytical workloads Set random_page_cost to 1.8 for DW profile on SSD/SAN storage, as analytical queries often touch >10% of rows where sequential scans are more efficient than index scans. Other profiles m... Pull #35 04 Feb 2026 11:22PM UTC sebastianwebber github
35.48
21691855955 seba/update-param-short-desc feat: optimize min/max_wal_size per workload profile Tune WAL sizes based on workload characteristics: - DW (Data Warehouse): 4GB/16GB for write-heavy batch jobs - OLTP: 2GB/8GB for frequent transactions - Web: 1GB/4GB for moderate writes - Mixed... Pull #35 04 Feb 2026 11:07PM UTC sebastianwebber github
35.2
21691703175 seba/update-param-short-desc feat: optimize wal_buffers for write-heavy workloads Set wal_buffers to 64MB for DW profile and 32MB for OLTP when shared_buffers > 8GB. Research shows these values can double performance for write-intensive systems vs auto-tune default. Add com... Pull #35 04 Feb 2026 11:01PM UTC sebastianwebber github
33.79
See All Builds (106)
  • Repo on GitHub
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc