Message-ID: <gh-postgresql-interfaces-psqlodbc-157@github.com>
From: "fdcastel (@fdcastel)" <noreply+fdcastel@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Thu, 05 Mar 2026 22:28:06 +0000
Subject: [postgresql-interfaces/psqlodbc] PR #157: Upgrade GitHub Actions workflow
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Id: 629408
X-GitHub-Author-Login: fdcastel
X-GitHub-Issue: 157
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-State: merged
X-GitHub-Type: pull_request
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/pull/157
Content-Type: text/plain; charset=utf-8

Closes #156

-----
**Key improvements:**
1. **No full PostgreSQL build from source** - x64 uses prebuilt EDB binaries (PG 17.9 binary archive, ~1 min download vs ~15 min build)
2. **x86 libpq only** - Builds ONLY the libpq client library from source via `meson compile ... libpq:shared_library`. The test server is always x64; x86 libpq is only needed to compile/link the x86 ODBC driver. No SSL needed since CI tests use localhost.
3. **Eliminated dependencies**: Win32/Win64 OpenSSL and pkgconfiglite are no longer needed (winflexbison is still required by PG's meson build system)
4. **Parallel matrix** - standard and mimalloc run simultaneously
5. **Separate release job** - only runs on version tags

**Results** (first run, no caches):
- standard: **8m28s**
- mimalloc: **11m47s**
- Total wall-clock: **~12 min** (vs ~25+ min sequential in the old workflow)

Subsequent cached runs will be even faster since the x86 libpq, x64 binaries, and all tools are cached.