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 1t6mb6-00FV6Y-2p for pgsql-pkg-debian@arkaria.postgresql.org; Fri, 01 Nov 2024 08:01:32 +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 1t6mb4-00B8DT-4p for pgsql-pkg-debian@arkaria.postgresql.org; Fri, 01 Nov 2024 08:01:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t6mb3-00B8DL-RW for pgsql-pkg-debian@lists.postgresql.org; Fri, 01 Nov 2024 08:01:30 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t6max-00498U-KB for pgsql-pkg-debian@lists.postgresql.org; Fri, 01 Nov 2024 08:01:29 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-a9a1b71d7ffso257949566b.1 for ; Fri, 01 Nov 2024 01:01:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730448082; x=1731052882; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=03+1bCyLQo4w26koz+wde61ChWctpFpLuzDCt1L45oM=; b=lrRECStDBl4jnH4N7ON+JWS5ncVnEctdkGA2gzvGdvn7J0d4znNb1moPPS2qBRDwIo RDc6UPPIzcWtS0BANtAmZCO6v/mXCTsI6K6f1kuxm+zeZjoBBv/vozNbYgpPoACxwEMK Sa2JU/Ze4opUzAzma1pZ+s/JP2mZEaq+kblRqe3xJnj0NlJp2J2uSAfr/vLcSzHzF6aR n5yjynLhjJRJKV5Aphd2GdxxbRXcJgR5vMjzefLalutbDI3IJLLV5E7oZu5GqVVqU7pa tk8q+18NwMFtEQy0bc1ggHNBrsUHkj/Yd+DDi2jNEb+PGBEINs16bmf3lhuxzzxDkCTv i+Eg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730448082; x=1731052882; h=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=03+1bCyLQo4w26koz+wde61ChWctpFpLuzDCt1L45oM=; b=JP+WSTJJRlsZAt3wmnyfVBbeQOQfHd/6XATXCX4p5mjEw+M+KtkBYLalIb26k2v2tF ECvEIjOITZ6MXW58szeyNAueqxKFBTw7PDdftaE5hZ1AoqQux0jADj/XOlcUhdrl7LUA YnOGidsTYgBFybvUPRVIZB7vcoCD7zgjLVS0xNAzvl/z0+q2+2ay/CieD0hWGpVvT+cU zHjhm+ay9/scYas6vxMmS+W7lzTiboFgK7JpSxlS4snXNtnlDQXHRtxA1XjeNL8iC/Wk Uy0b1wWJUH5V9s4E7pyJsR/q8NTXiERQu/nNGKejgKcSgt26B9qYBvBN21nbBTx+HdKn XWmQ== X-Forwarded-Encrypted: i=1; AJvYcCUALAEWW97QlTNNBgPKcSSBdL6fLLN72LeOYZnvKadXbJDPlzrm6/btof4xhq6xBASB/X9rc3ZnrSQHf584cXPB@lists.postgresql.org X-Gm-Message-State: AOJu0YxguArU9fzCKIFUX3By/cyQpaHG7517kvcOS5Dj6HYsVRlw/DUe PIjVVOIhD7CQjhB/ekQijS52YennxP0101D3T6rbLaYdTXqPrj224QvfrtUmwhN0XP+Nl81OUis T0FayGcWRznlOFb/yNjCS2xjekDA= X-Google-Smtp-Source: AGHT+IE9Uwz5S83hzxhvA6D2Ki0g0w8eucvjremhMXVpts+Pv8QWRE1GPKuF5LiO42R6aQWa3H01iTwDGCwCoczWIAU= X-Received: by 2002:a17:907:7292:b0:a8a:6c5d:63b2 with SMTP id a640c23a62f3a-a9e3a5a049emr1028195266b.18.1730448081933; Fri, 01 Nov 2024 01:01:21 -0700 (PDT) MIME-Version: 1.0 References: <4c7a93ff-2650-4ca9-84cf-2744e6b15654@ulb.be> <1ab16dc0-3ce9-42a0-b4e8-2e4ba47e2877@ulb.be> In-Reply-To: From: Esteban Zimanyi Date: Fri, 1 Nov 2024 09:00:47 +0100 Message-ID: Subject: Re: MobilityDB 1.2.0 - New upstream version To: Bradford Boyle Cc: Christoph Berg , SCHOEMANS Maxime , "pgsql-pkg-debian@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000039e0150625d5575d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000039e0150625d5575d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Apologies for the late reply. I can work on optimizing these tests this weekend and will send a PR to the MobilityDB master branch so it can be cherry-picked from there if needed. ------------------------------------------------------------ Prof. Esteban Zimanyi Department of Computer & Decision Engineering (CoDE) CP 165/15 Universite Libre de Bruxelles Avenue F. D. Roosevelt 50 B-1050 Brussels, Belgium fax: + 32.2.650.47.13 tel: + 32.2.650.31.85 e-mail: esteban.zimanyi@ulb.be Internet: http://cs.ulb.ac.be/members/esteban/ ------------------------------------------------------------ On Fri, Nov 1, 2024 at 4:21=E2=80=AFAM Bradford Boyle wrote: > On Tue, Oct 29, 2024 at 12:06=E2=80=AFPM Christoph Berg = wrote: > > But 096_tnpoint_spatialrels_tbl is a pain point - would it be possible > > to speed that test up such that it passes in, say, under a minute on > > amd64? Then it would likely be fast enough to pass on riscv64 as well. > > I am not familiar enough with 096_tnpoint_spatialrels_tbl to know if it > can be sped up beyond just omitting some of the queries in the test > script. I can change the autopkgtest to omit this case if we want to > minimize the performance impact on the build infrastructure. > > --Bradford > --00000000000039e0150625d5575d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Apologies for the late reply.

I can wor= k on optimizing these tests this weekend and will send a PR to the Mobility= DB master branch so it can be cherry-picked from there if needed.

-----------------------------= -------------------------------
Prof. Esteban Zimanyi
Department of C= omputer & Decision Engineering=C2=A0 (CoDE) CP 165/15=C2=A0 =C2=A0
= Universite Libre de Bruxelles=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0
= Avenue F. D. Roosevelt 50=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0
B-1050 Brussels, Belgium=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=C2=A0
fax: + 32.2.650.47.13
tel: + 32.2.650.31.85<= br>e-mail: este= ban.zimanyi@ulb.be
Internet:=C2=A0http://cs.ulb.ac.be/members/esteban/------------------------------------------------------------
<= /div>


On Fri, Nov 1, 2024 at 4:21=E2=80=AFAM Bradford Boyle = <bradford.d.boyle@gmail.co= m> wrote:
On Tue, Oct 29, 2024 at 12:06=E2=80=AFPM Christoph Berg <myon@debian.org> wrote:
> But 096_tnpoint_spatialrels_tbl is a pain point - would it be possible=
> to speed that test up such that it passes in, say, under a minute on > amd64? Then it would likely be fast enough to pass on riscv64 as well.=

I am not familiar enough with 096_tnpoint_spatialrels_tbl to know if it
can be sped up beyond just omitting some of the queries in the test
script. I can change the autopkgtest to omit this case if we want to
minimize the performance impact on the build infrastructure.

--Bradford
--00000000000039e0150625d5575d--