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 1u7ULP-0002SB-5l for pgsql-general@arkaria.postgresql.org; Wed, 23 Apr 2025 07:16:31 +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 1u7ULM-003p3e-Po for pgsql-general@arkaria.postgresql.org; Wed, 23 Apr 2025 07:16:29 +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 1u7ULM-003p3W-EA for pgsql-general@lists.postgresql.org; Wed, 23 Apr 2025 07:16:29 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7ULK-001UVv-0W for pgsql-general@lists.postgresql.org; Wed, 23 Apr 2025 07:16:28 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-ac7bd86f637so121791866b.1 for ; Wed, 23 Apr 2025 00:16:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1745392585; x=1745997385; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Ivqt21nzUOrKTDV4dDRNk3Yi9hKh5brWtKpEZAsytYE=; b=eU0K63b43GADXZANlZ38fHZCceoHmbXjDGCrwMRkOIg78AOtKXkts3fWwkmsPCUZLR MrHChmjJHixWUTWLA20ftpKW4FPRTwBw+Sgb/DGpw71GDmaqaJxpYsNWz44Zq/qNvXB5 PVs0eZAzfI6s7SD73x+jHekl4MWaJp386E+5Uv/LkmgwrIatnFPh9vMepyGr4ybuV22+ ofesng+tfYpy0zOU6iYgIy4bnHjGALiWkLyXbcVaGDidI0RPPXL45mAevZFETwJTNl2y Gkq4yWfYIRuJAMChzUZw/2WAEG1Ky8Z6/w9vsEonF3rRHqoW7R7RLXqe/AKy0xU7hq7X yXtg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745392585; x=1745997385; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=Ivqt21nzUOrKTDV4dDRNk3Yi9hKh5brWtKpEZAsytYE=; b=LUTSTN5nrT9EW64I4YoDdSB+KcPLBKYFRrZzwy6bVKiOc/Pdk0QptV45FuxjHP6KNJ qe94J8UMYxT9mAIK/cmqOQ6px9uBByn2qzJgDnqYvArNZqtlK88t65Vz34uuBPelAxF1 9Y5NnQo+gA5LOXLDEZ4pQ59/4Ooc5HYccaA8SnyvknYXikDIPPymLFKdqG9/EmoTWsyV Vsj5zswsCiBvWWHB9WPLdoIx7h8GVz4yBtzwyG2Ofa7oOUNcEIE1hpqF8/J6gF/BmTcw /hCdmd1/CyXQBrwQR+nBRr5iXN8kWIAwIGF5pGmkiniPtPPgthsShe1b+tyMMQQDJhzL 6iWw== X-Forwarded-Encrypted: i=1; AJvYcCVqNkVF9vwqFHPepj1peDFab+Lh6+8qeP9oNc/DtObWa20/kgHuJXXKgbyE43XBomL9qahPuBbqLBRAAPQw@lists.postgresql.org X-Gm-Message-State: AOJu0Yzx4p+5un3ArYctmIrX1I2qn+Fq6IeXJRCMR6h8+P1YRlg+TyuK s7/DC7K9tSiRQFG7f6jhBqYwVSjtVuVxZl3FmOixlw0mOY9TXTrdvgXXTYcAiGLpeKg3zjjsB91 Xl4s= X-Gm-Gg: ASbGnctO8iPLVYJqSEOw1waBtfZsz13bfSvN0TXXZhnGOxIn6k7bc+qWZnMBScnteCG JlLGxrTiBP5OIUq9HVoC1btdJeOg1G4aVIgTVKHVrblYplqDC1svOtWcicBZLEtUhjkbZX0JzB2 tsAujfKLiCwoycz212VISrBtlZXL/pvWJqnRRGfZuYFWCVc20cA8NTi/kcsC8wUAJAnxtEEGhhy DmUgU4cHUUDG3OEfKHRgkKyOkC65l5ldwU2cAKi+KdHqO5PJ+2DbNQkrSjMf65z27wawwMNRK+d qKL9L9nYKlz7L7u6M0gL3SqMjq2nGaxswHxnp3CoASsse2pLx+q4CmkS4A== X-Google-Smtp-Source: AGHT+IGjeIpGbMR0ibYQTn1kRBVfJ1xE3Vm/2+kGAFYDPgAwOdwPY9EMhAtcnlm8HNKpceUb+ZtqKg== X-Received: by 2002:a17:907:1b1c:b0:acb:aa0e:514c with SMTP id a640c23a62f3a-ace3f280ba1mr170462466b.2.1745392585109; Wed, 23 Apr 2025 00:16:25 -0700 (PDT) Received: from localhost.localdomain ([41.66.99.117]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-acb6eefcf4fsm769435866b.109.2025.04.23.00.16.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 23 Apr 2025 00:16:24 -0700 (PDT) Message-ID: <03763b6b43cfd8a7194c2fb06452178db4256494.camel@cybertec.at> Subject: Re: Another documentation issue From: Laurenz Albe To: Igor Korot , "pgsql-generallists.postgresql.org" Date: Wed, 23 Apr 2025 09:16:23 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-04-23 at 00:21 -0500, Igor Korot wrote: > On the page https://www.postgresql.org/docs/current/runtime-config-query.= html#GUC-SEQ-PAGE-COST >=20 > it is only given the default value of this parameter. >=20 > No min/max values are provided.. >=20 > The same can be sad about > https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-RAN= DOM-PAGE-COST Sad. But you can interpret it as "there is no maximum". The actual maximu= m is DBL_MAX, the biggest double precision value that your system can handle, and may dep= end on your architecture. > However, this page > https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-= EFFECTIVE-IO-CONCURRENCY > describes both default and mn/max, however t s says: >=20 > [quote] > The default is 1 on supported systems, otherwise 0 > [/quote]] >=20 > No explanation of what is "supported system" is given... >=20 > And the same can be said about > https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-= MAINTENANCE-IO-CONCURRENCY. According to the source, it is "systems that have posix_fadvise()". We cou= ld document that, but I don't know if it would help many people. I am not sure how easy and = feasible it is to research which versions of which operating systems qualify. Yours, Laurenz Albe