Re: Heads Up: cirrus-ci is shutting down June 1st

From: Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>, Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>
Subject: Re: Heads Up: cirrus-ci is shutting down June 1st
Date: 2026-06-02 10:13:09
Message-ID: CAKZiRmxL3Yx6B0r5OUH-8qHPbw+VJcDWf3fTT-9UFNUJ28=H_g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Andres/Nazir,

On Mon, Jun 1, 2026 at 11:57 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> Hi,
>
> Attached is an large incremental patch onto Bilal's version:
[..]

> Thoughts?

The timings I got during morning EMEA hours [1] (my first GHA run) was
with all those commits except last one, and it's LGTM (it's a flawless
experience
at this point as end user; all succeed). Perhaps my only worry would be
success of this and proliferation of using this often, where plenty of people
hit download those packages at runtime (MacOS/Win) way too often (or
download sites being unavailable and causing outages in the pipeline).

Continuing on previous story...:
Windows was still @ 31mins, and whatever I've tried it is was not helping it
(but I cannot measure inside GHA Runner what was happening, so those were blind
shots with fstweaks, etc). One important thing, altough I failed altering
CacheIsPowerProtected (avoid flushing the write cache) as it seems impossible
for me to do so on D:\ (as paging file is there and and altering it also
requires reboot), at least we know stuff is way slower than it could be on
those runners:

"Get-PhysicalDisk | Get-StorageAdvancedProperty" reported:

FriendlyName SerialNumber IsPowerProtected IsDeviceCacheEnabled
------------ ------------ ---------------- --------------------
Msft Virtual Disk False False
Msft Virtual Disk False False

Perhaps there's way to use some custom image/templ with different settings,
especially for D:\, after all it's just volatile stuff. Thoughts? (not that I
care that much for Win, but waiting half hour for it finish every time is
not going to be nice...)

Also, maybe that's not useful for for GHA/CI, but for folks trying to local test
on win32:

I've run some quick test on my own Windows VM with manual "ninja test".
Immediatley spotted Defener as top#1 CPU. In GHA workflow we already
this thing for disabling Defender AV:
"Set-MpPreference -DisableRealtimeMonitoring $true
-SubmitSamplesConsent NeverSend -MAPSReporting Disable"

Yet, when I re-run the verification command it showed still as as enabled (!)
and I've still got Defender as top#1 CPU during next ninja run, so disabling
RealTimeMonitoring didn't kick in? So I went and I've manually disabled
"real-time protection" in "Virus & thread protection settings" in the control
panel as it was still on after above and only then it got a nice boost
(even visually when watching tests). Gemini told me later that there's
"TamperProtection" thing (!) to ignore powershell. see e.g.
"Get-MpComputerStatus | Select-Object IsTamperProtected"
and it requires manual human steps to disarm... but apparently all of this is
not necessary on GHA...

-J.

[1] - https://github.com/jakubwartakEDB/postgres-public-ci/actions/runs/26806653438

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2026-06-02 10:19:12 Re: Row pattern recognition
Previous Message Hayato Kuroda (Fujitsu) 2026-06-02 10:01:07 RE: pg_createsubscriber: allow duplicate publication names