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 1tuhUq-00Aqdo-Nx for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 00:41:24 +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 1tuhUo-008kYQ-ON for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 00:41:22 +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 1tuhUo-008kX6-Db for pgsql-hackers@lists.postgresql.org; Wed, 19 Mar 2025 00:41:22 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuhUm-003bNG-2F for pgsql-hackers@lists.postgresql.org; Wed, 19 Mar 2025 00:41:21 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-6fead015247so47043957b3.2 for ; Tue, 18 Mar 2025 17:41:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742344880; x=1742949680; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=OflsxZYKjgT2cJQj4V1pk5NWY9eqvZAGgPVTWQE8IFo=; b=XaxV7RI81AKgICUc2GUIM2US6ScoAC02NTY/gdO3r4+SkRZO5s78wNF6zKnH09Psr/ 1JXBt/esCDTKjkA+dSNfT9FFloAAARam+WbuUtcqOTRdVevz3GY5deKRk7KVibZlhJ4p /qdv0CFH9izuQE+WDi8nztFgM9xWQfLcKHmLUY6xuNE6zfkvM6vltdn2HboRgv0xfoMK tv2g8tZQl7bjylnWgp/X1xRxwzDZL36I+gEXuH2PhcpUBvMX44pOPqeRUp4NR6DP6o3Z p/odrn1mAYbTYTA2aelLRJYnVf3Mrs5pYwScxGLWCce1OrVtzHEdw5mjZYX2i0Zor511 qKrg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742344880; x=1742949680; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=OflsxZYKjgT2cJQj4V1pk5NWY9eqvZAGgPVTWQE8IFo=; b=lpemcWKWht0HqpX1aqCUwDZ+mIlg6TF+5UJC/pumeq8z9jWzi2i7q8Zpv1A8W7nLi+ yYP7yMp+whnkbb+mwCoDHU8gzAFbVzWTzjebbiHZ1lhN+d+7urevuO/F//LkB+Ng1xv1 +nsyzWewp+NrMABZdqiAvEtdn3lC+cq/BRdRhgnPkS4Bmc6Ub7JIuFSLDfl4n5pAeixd M7Zrpj4jepht/Mxkt4TExHoIC48gPl5oPYvzWPXWNLJUyAJX8amx7rfG1EN6JgXmFn0L oZUnkhYVRSzCWykmmVXygo1ho3GUd07wK42Li2iIwew1iV+TYz2bv4oAUXI4RW1euW2y nWmA== X-Forwarded-Encrypted: i=1; AJvYcCVqz61Qua26cKEuk9UTyPPF8w5RqKPJe2ogSmip6z5bCcURW6S5JFOLzGWtzypf34oX6556vX/7EgbwVxKs@lists.postgresql.org X-Gm-Message-State: AOJu0Yyte/wJbOwpCrnS181q6cWzhW/IVZKNb1ojq6VOllPd1DsfUF4M SxxT/EvWt8J26JSiJbnYAgHZtmvMD5t5sl7ibhbAEwBxnl27hkSD X-Gm-Gg: ASbGnctk064XJzampIjKwTbLvR3wqo5VFql3MDcRz0IF8gfLg4nCD8uhrEJPl7aKLct DtRrP8+I8qeQ4w+H4IAg2XtLaUdY1xanMxqWxUEXnSIWQL5kl7UEhYqriyu9PMDPRAY+8tNdGEd zZ+U00pWVFg+Aoj0ePLwYzuwyu3Rfymp4QU56fd6pwqfZavXx71LMcBPgIfGD3q7CaFXaql24KC SkVRXfn9YQCPW9yVub9mYhEpUXLJ427gO/PtExCUv7NSlQ+O/i5QVHUNqii7MvSnHUTGbYJb//k 5FgSuAde6WEMtWRfuyS7gwfBOmJW8HHf3FGr9xyiRLZkskzu8qyr/oiCCO5sYd5bMmFvw/A/B1V ojbMJcakL96CZWRiow0WgyjgOz7ulO445/nswKnwS X-Google-Smtp-Source: AGHT+IEsp/SdyHimXaDB2TSUZHTQDfhi9HPdSUYBY/6CVP+GtpJcK5sdXb+m9+Jm9pLIexnDSih/kA== X-Received: by 2002:a05:690c:6089:b0:6ef:6536:bb6f with SMTP id 00721157ae682-7009bf9f410mr13427707b3.22.1742344880057; Tue, 18 Mar 2025 17:41:20 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 00721157ae682-6ff32842c8csm28478867b3.17.2025.03.18.17.41.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 18 Mar 2025 17:41:19 -0700 (PDT) Date: Tue, 18 Mar 2025 19:41:17 -0500 From: Nathan Bossart To: Andres Freund Cc: Tom Lane , pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: aio: Infrastructure for io_method=worker Message-ID: References: <593800.1742338428@sss.pgh.pa.us> <27fwadt6whe5ufqyrgbrnu3ppfiocaljtt3fufedn6sclvjqll@kotindcvgtoy> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <27fwadt6whe5ufqyrgbrnu3ppfiocaljtt3fufedn6sclvjqll@kotindcvgtoy> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Mar 18, 2025 at 07:07:53PM -0400, Andres Freund wrote: > On 2025-03-18 18:53:48 -0400, Tom Lane wrote: >> It's probably time to just abandon the idea of being able to run with >> only 60 semaphores. > > Agreed. It's an absurdly outdated OS default configuration. Realistically one > can't run postgres even in a toy scenario without changing it. So the value of > being able to test postgres with the default OS settings doesn't seem that > high. If it were on a very commonly used platform I would think differently, > but net/openbsd ain't that. +1. The platforms with low defaults do force us to think carefully about increasing the default requirements for Postgres, but I don't think that's a strong enough argument for the maintenance effort. -- nathan