| From: | "Jelte Fennema-Nio" <postgres(at)jeltef(dot)nl> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Andres Freund" <andres(at)anarazel(dot)de>, <pgsql-hackers(at)postgresql(dot)org>, "Peter Eisentraut" <peter(dot)eisentraut(at)enterprisedb(dot)com>, "Nazir Bilal Yavuz" <byavuz81(at)gmail(dot)com> |
| Subject: | Re: CI slowdown due to PG_TEST_INITDB_EXTRA_OPTS |
| Date: | 2026-07-20 21:47:16 |
| Message-ID: | DK3Q8SC52NHB.SGQ8FXBIDLCP@jeltef.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, 18 Jul 2026 at 20:48, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> It looks like any one job mostly uses the same value of
> PG_TEST_INITDB_EXTRA_OPTS. Could we record what was used to set up
> the template, and allow using it if that matches?
Yeah, that seems to work pretty well. See attached.
I'm getting similar test timings in CI with this as Andres got for the
Linux runs that he did when removing PG_TEST_INITDB_EXTRA_OPTS.
For MacOS I see basically no improvement though, I guess that's probably
because the debug_xxx options actually incur significant overhead. Maybe
it's worth trying to move them to one of the faster runs. But that seems
like a separate discussion.
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Keep-using-the-initdb-template-when-PG_TEST_INITD.patch | text/x-patch | 9.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haibo Yan | 2026-07-20 22:21:20 | Re: Checkpointer write combining |
| Previous Message | Greg Burd | 2026-07-20 21:34:41 | Re: Tepid: selective index updates for heap relations |