| From: | Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Use windows VMs instead of windows containers on the CI |
| Date: | 2023-01-10 12:20:18 |
| Message-ID: | 211afb88-6df6-b74d-f1b7-84b5f21ad875@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I propose using windows VMs instead of containers, the patch is
attached. Currently, windows containers are used on the CI, but these
container images are needs to get pulled on every CI run, also they are
slow to run.
These VM images are created in the same way how container images are
created [1].
The comparison between VMs and containers are (based on d952373a98 and
with same numbers of CPU and memory):
Scheduling step:
VS 2019
MinGW64
VM [2]
00:17m
00:16m
Container [3]
03:51m 04:28m
Execution step:
VS 2019
MinGW64
VM [2]
12:16m
07.55m
Container [3]
26:02m 16:34m
There is more than 2x speed gain when VMs are used.
[1]
https://github.com/anarazel/pg-vm-images/blob/main/packer/windows.pkr.hcl
[2] https://cirrus-ci.com/build/4720774045499392
[3] https://cirrus-ci.com/build/5468256027279360
Regards,
Nazir Bilal Yavuz
Microsoft
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Use-windows-VMs-instead-of-windows-containers.patch | text/plain | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jakub Wartak | 2023-01-10 12:23:19 | Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs |
| Previous Message | Jelte Fennema | 2023-01-10 12:09:44 | Re: Allow +group in pg_ident.conf |