Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tlgLa-00199C-Vm for pgsql-hackers@arkaria.postgresql.org; Sat, 22 Feb 2025 03:38:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tlgLY-004BsG-0n for pgsql-hackers@arkaria.postgresql.org; Sat, 22 Feb 2025 03:38:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tlgLX-004Bs8-NO for pgsql-hackers@lists.postgresql.org; Sat, 22 Feb 2025 03:38:31 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tlgLS-0004jI-1f for pgsql-hackers@lists.postgresql.org; Sat, 22 Feb 2025 03:38:29 +0000 Received: by mail-ej1-x62b.google.com with SMTP id a640c23a62f3a-abbc38adeb1so475696266b.1 for ; Fri, 21 Feb 2025 19:38:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740195503; x=1740800303; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=dyaDKmyxlWVI0SV+bKVkefX+6pDTvfdhhCOd9wxScOw=; b=KSsjrFcN/ZlY7D+kEfcqGje4xYhwZRur9T72pYMFwLD0X02bMA9WmweUCZDJFLf1On ItPSKnUy7a7o8LtxfZ8ABefFUyPLUpmuIvsz2gtajdUGmX6rmoxTcp5xxFX2YwOIKm1b palKR60Zo+5/7RvsqG2rQczpK0h70BOe2zkAPwD1DF8XAYXJQMpywcWl88zFCXjePTwO yuGJZt373PTbgjVyEuxhEaXj82mov5c60GTvFLB2SJcEewijIgjl7j3vFSo0dQ3wKfFP aUATxZCpKIRqmnrPanZcH4RvY8FmJrdRtVp614uM66suQvL2VMyZY1hQEAm0mYt27mEj 0lxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740195503; x=1740800303; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=dyaDKmyxlWVI0SV+bKVkefX+6pDTvfdhhCOd9wxScOw=; b=Ae+oAy/5lz7xZ4iSwzyrPyl4KzszECabUYeJ+0aJHEDHfTEBp+KbD2SEeC1uEKj1TP 4NSL7PZXRuF5/TGaTe88XOwUznHi6vfNaNfTUWAYWMsUTzF0f3foAj8jhu7lzjU0wCPk plY1IvQMZrt1/OpETqBqFsw66W0BgtdFpXjJn3tLad01n865Z03RjXUawaDAb+V9iP1j mVUGYTmoU02UAKlsxoOxYSbPFOIVaVKmaRYVtvc173R0saYYVdIewxOenjABHZxLm6C2 B5J6WC3CTcmjmR9b3kkZfoHsui9MWedj7CmIkwaRJOSBWn879q83J8Q5sk+/Tn7tMTIY /k3A== X-Forwarded-Encrypted: i=1; AJvYcCUzQZ533xaSOs1a+SRd1bDatNS8FbD4PSuO1Yon6UOQAM9EqqupqCr6Da6HRju8k+6ETJOhNAcI6hXzUZqr@lists.postgresql.org X-Gm-Message-State: AOJu0YwBKmQknGYUioz2Wnnx89brLDydSl3WalL5XVLQHYXg1g5wQUIj e4P0TkMlBvlO+8Qvmj2qD7MYi3rxYpANhsFdWWAULur2xwJMn8gKj4nDA5hvl2zl6d3ZORbVwZ3 tZ5G+YW5zj5dg7T1oVN1chFcgDmU= X-Gm-Gg: ASbGncv63wnMPDIZCVwY1WCKBS0v70ctGwotlAXYK63+LZzbPfEuY54iqWunD4oU0B7 +8TpIEAmn1hWSSeD7ft325k1bqVU9BFHe+PLSUgtU5jpv4Abr7QKOH3le8q8PtnmrQ8t+5qC7TM AQLIT820I= X-Google-Smtp-Source: AGHT+IG6xF3w11oz5S0a+uh7JS15U/pvsbbHvXuA0v+tPmUPNpqhKg4dbz5E+ty98qfja99O/tjd/jgAesDYLW+Lals= X-Received: by 2002:a17:906:794e:b0:abb:d9c6:ecb2 with SMTP id a640c23a62f3a-abc09aa9b80mr528892966b.21.1740195502928; Fri, 21 Feb 2025 19:38:22 -0800 (PST) MIME-Version: 1.0 References: <01ec86c1-e04b-4cbe-b641-22cae8b87604@tantorlabs.com> <73e2440e-7d8b-4860-974d-931a93326d95@gmail.com> <3737950.1740182671@sss.pgh.pa.us> In-Reply-To: From: Robert Haas Date: Fri, 21 Feb 2025 22:38:11 -0500 X-Gm-Features: AWEUYZlYK9RRC3Gc9C69QtgjZBIId5J6xvoPZUUOCBrNqLWWytMi48MFn11IUUU Message-ID: Subject: Re: a very significant fraction of the buildfarm is now pink To: Andres Freund Cc: Tom Lane , Ilia Evdokimov , Andrei Lepikhov , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Feb 21, 2025 at 9:14=E2=80=AFPM Andres Freund = wrote: > I'd also say that breaking CI and BF is probably something I'd consider m= ore > urgent, as that could indicate the commit was just generally less well te= sted. This is possible, but I think we oversell it by quite a lot. It's quite possible for someone to put hundreds of hours into a patch and forget to check CI before pushing; and it's also quite possible for someone to do a terrible job vetting a patch where CI is clean. When somebody is already stressed out about their patch breaking the buildfarm, the very last thing they need is somebody who hasn't read the patch or understood what the problems are to show up and say "hey, maybe this patch should be reverted for all time and never considered again ever!". It's just making a very stressful situation more stressful. And it's cheap. If somebody shows up and says "hey, this was improvidently committed for the following six design-level reasons," that is abundantly fair and deserves major respect. Such reviews take real time, thought, and work. Idly speculating that someone's failure to check CI is a sign that they've also done everything else wrong takes almost no work at all. I hate that we do that to people. As much as I hate it when it happens to me, I think I hate it even more when it happens to other people. It's a terrible way to treat people who have poured their heart and soul into becoming committers and who really care about the project, at least until we beat the caring out of them. But the real point of my previous email is that I just do not think it's reasonable to expect people to fix complex programming problems within hours. As much as I can be grumpy about CI, anything that goes wrong with CI should in theory be something you can avoid ever having to deal with on a Friday night no matter when you choose to commit, because you can test things in advance. I know the BF has more configurations than CI, but instead of having LESS capability to test things in advance, it has NONE. Twenty years ago, post-commit testing was probably the best you could hope for, but today it isn't. --=20 Robert Haas EDB: http://www.enterprisedb.com