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

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, 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-01 14:41:35
Message-ID: ah2QDZyOKgW9yU9D@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-Jun-01, Jakub Wartak wrote:

> 5. Spotted that we do plenty of initdb and cached-initdb (cp), so I had idea
> about XFS's cp reflinks=always in build/, but I couldn't do that without
> /dev/loop, so apparently XFS (reflink=1) vs ext4(reflink=0) halves number
> of writes while even still on /dev/loop device, but that somehow
> does not directly contribute to duration of the test (well we are
> bottlenecked on CPU anyway, so this is just smarter? way of avoiding I/O;
> maybe with cold-caches and on real VMs running with XFS would be faster)

I wonder if we could somehow make several test use the same instance
instead of each creating its own. Look at src/bin/scripts/t/ for
instance: we have 14 Cluster->init() calls there, 12 of which have no
arguments; that means we could use just one instance for those 12 and it
would mostly be fine. (There is some degree of dependency: for example
if two tests create the same database, that would at present work fine,
but with a common instance it'd fail. Should be easy to fix though.)

The only real problem is that we have no mechanism to share the same
instance across several .pl files. Maybe there's a way to do this in a
smarter way?

Maybe have 000_create.pl that does nothing other than Cluster->new(...)
and Cluster->init(), and then the other scripts simply do
->init_from_environment() to reuse that instance. Or something like
that.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"Porque Kim no hacía nada, pero, eso sí,
con extraordinario éxito" ("Kim", Kipling)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Srinivas Kumar 2026-06-01 14:57:35 Re: DBeaver Experiencing timeouts while connecting to New Linux PostgreSql server
Previous Message Robert Haas 2026-06-01 14:00:27 Re: should we have a fast-path planning for OLTP starjoins?