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.96) (envelope-from ) id 1wAISR-002FJ1-2g for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 02:15:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAISQ-003zcS-0a for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 02:15:54 +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.96) (envelope-from ) id 1wAISP-003zcJ-2r for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 02:15:54 +0000 Received: from mail-qt1-x844.google.com ([2607:f8b0:4864:20::844]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAISN-00000001Dqb-2vgL for pgsql-hackers@postgresql.org; Wed, 08 Apr 2026 02:15:54 +0000 Received: by mail-qt1-x844.google.com with SMTP id d75a77b69052e-50d6144877aso57268961cf.3 for ; Tue, 07 Apr 2026 19:15:51 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775614550; cv=none; d=google.com; s=arc-20240605; b=aK0vbZdPY3JCrxfvs0x9BMQom0dpjbtbyee5+oEjOrvbRFE8uF6N39IUy22mUSPVdZ 3RJxwU2njEZG1JHDffjSlnmBPJk58ChqPjgXWuPo7oExTb1cCginY8mF/REZbBMkFxzT htqVDM53B3XONteHRCW1Ig/mzzpU2iu6ozs1Rdng1WnGw6+fez/YD74GjoaWm37NqqAO MD/xotY2bVNWCxsSb08Ldoc9kDFQ+Dpm31tQ//4xVgOWTdy9bi6+RFQJiElvAqNmxsvh wl2AmCVgIWr22JazAlMZ3s/OQYTtWW1/UW1bmQiZlHIcidIPeJydE/Bofu3VjNO0U3DW A66g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=rDk45ua9ZsVlvmdYxnGMjyp3Bbaz0W97OFp3LdkAwa0=; fh=cXYRR9PHa2DnLzNn5YvgXIAGwuv86dprYcc1owRnPss=; b=AaGv4eqQj92BAiGDcVr87i/58IYbxiJFSfHHWGWDrAfT8edZ3/5EYkWWYeuRV2MmmA U7EK7B83wINNopz6p9ypFoRx2u9kY3lh6qDw8kIE4xAOfjfGzzsQFsaOjN+JiN2GW1L1 ZODOSRDzCG0rQyHfU4AMVfnyCJtq/ugZZajiE/CdW6ScPj9nV8q4kdPRNPL43B3yJPKy +FDP6ElwLp80a/mEBhcgTw6qAzYpHHaN50GMcsfJcTLnI0SgutmVOD7LOU3Kn9R+Bz9F 0WvDsiox0s5dzvbcFiXMjTOsuu0fkcb8cXkrEJHCEIZKptWvLfhGWGJDGQuQqmpEXkb8 dgEA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775614550; x=1776219350; darn=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=rDk45ua9ZsVlvmdYxnGMjyp3Bbaz0W97OFp3LdkAwa0=; b=hdgDIwFbu3H0V7e7arzLEFRv9HmWqDs4vqya6+E1nRgwmKLB+AWNkeawhPneckcl3L p0jZPhS7GRJ0Zy/80Y+ZOcy5IWxPZezS3Ejbl1mQurWex35swpFcWbozmQPbzb0U0Cg6 YTEv29qqMnWwPi037fHTSTFKOBrbuc2g6pv7UFVVoAL3cM0I8rEcqCV+vYa5yRo4wCg8 rympejKtLIYAe8cFMgW41Y7885oJ4QyhQoFFml65AmETp/obYVL1Eg2Ued4pAGrmpn7u 2p7ZMetwngZ9JEfy/4PNmj8F7q7Dqgy5UfR+bzcUk3XbFT1WKzcNus36w0/349tRSSjj k3dw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775614550; x=1776219350; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=rDk45ua9ZsVlvmdYxnGMjyp3Bbaz0W97OFp3LdkAwa0=; b=Iebq0oT+7u2ZD9TlsKkEyOKI2oHZKdRSshZLIF9w/mzs/fAMoDmjlr+DEjJkC5PprS Bf/jhloaBMI7XaN9olr7tQ1FnnV6ax9T3dD6WbTvtGxwJ3A23ZuV6d0iuT+lBqm1i5MF FEMHH5J72qtHDY2X7BlHI3EFqsQD4Lys4v5GMVsfRUmXgFtHWsBY7ks7j6nms/WnFOJ5 8Y7eQOcUloxlQGaAOR6NWTPidhwCYiAA5OkSftiaAcvHhyveIqnZHs1Zqt/muQn7qqF/ SEFd/SS6klWsr+mIXyHowP/F0uKHe8HWhr7S9ILrVxXle9FCcQaDCOiT2TZp6ef1enY3 +pkQ== X-Forwarded-Encrypted: i=1; AJvYcCUSNrunR4rgkbsYcZnVnpmbFQfIiH6jW9iNoBO8Zx8HSFWfsg1k1EKFIeql4T3GVTeDYUrYkDKF4K7p2sZT@postgresql.org X-Gm-Message-State: AOJu0YzEigUMZGswRc9x/+Z1/FqJVO3PGqef+pdKUoaIVy//+Xc0soNb mX2rYLVNulKVdG+psw7nIQsPuoTWSumGngEeABoNtAS3qvLv1wL4f0sI5BNVAIOknSzz05g0fLo hWccg+w5Ze7/A5NVYYW/x6MK2v8YOE1w= X-Gm-Gg: AeBDiesssqD6vkSQxC4a3MsV5Z3jTV4yZShuEbBOlmX/n/GUWdU5UYbkXa1EyVOcX0K j2DR6uFhjMx1sgxECmuVNO87islYWRd+tyzmLUovvpBSDbbZs09+zOwqXqCgyTCk8ukiOwFOMtW EZOtmXOQvkrYBlOlI4LB5+iXH9eYnG6GyJzuuHsvAKTP6GQ54ecVqmOQW74D20r0nvYvipeh7yJ W6YFh5Nrf5zSztT3DS/sSklaLCnI/R1fVJzhec1hcEEEjwS7/SnlbNHjW5qgGCfmZYqu7bIw7zZ eOdSzs9xoBRdCfdBS7xCKoMrnUpHoM2csUQ9RdEZwnAAbgTUZ92igclHlZdFLnafTBp13a1qS/v rJ1kA7FzdxH5cvtf7uFgfwox8xAg= X-Received: by 2002:a05:622a:2b4b:b0:50d:8727:b1da with SMTP id d75a77b69052e-50d8727b7f2mr197680051cf.39.1775614549991; Tue, 07 Apr 2026 19:15:49 -0700 (PDT) MIME-Version: 1.0 References: <5d366878-2007-4d31-861e-19294b7a583b@gmail.com> <9ac3931a-180e-4283-a7a8-05eb66099206@iki.fi> <2e11134f-02c3-43da-8c39-fb520a1a251d@iki.fi> <66620ec7-0f81-4813-9cf1-b901a56efcc3@gmail.com> <2a76b5ef-4b12-4023-93a1-eed6e64968f3@gmail.com> <6439c655-e281-409d-b884-6586750d5820@iki.fi> In-Reply-To: <6439c655-e281-409d-b884-6586750d5820@iki.fi> From: John Naylor Date: Wed, 8 Apr 2026 09:15:38 +0700 X-Gm-Features: AQROBzBcED6pUE3yfxhou8E87E6E9EkzzMnf7rkgAyN13u37jXuSe-L--bQ1iHQ Message-ID: Subject: Re: Reduce build times of pg_trgm GIN indexes To: Heikki Linnakangas Cc: David Geier , Matthias van de Meent , pgsql-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 Tue, Apr 7, 2026 at 6:27=E2=80=AFPM Heikki Linnakangas = wrote: > But the comments on the pg_cmp functions say: > > > * NB: If the comparator function is inlined, some compilers may produc= e > > * worse code with these helper functions than with code with the > > * following form: > > * > > * if (a < b) > > * return -1; > > * if (a > b) > > * return 1; > > * return 0; > > * > > So, uh, is that really a universal improvement? Is that comment about > producing worse code outdated? No, it's quite recent: https://www.postgresql.org/message-id/20240212230423.GA3519%40nathanxps13 -- John Naylor Amazon Web Services