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 1u7oqc-007DMq-U0 for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 05:10:07 +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 1u7oqa-00D5Fa-S4 for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 05:10:05 +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 1u7oqa-00D5FR-DS for pgsql-general@lists.postgresql.org; Thu, 24 Apr 2025 05:10:05 +0000 Received: from mail-yw1-x1129.google.com ([2607:f8b0:4864:20::1129]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7oqY-001iiz-0L for pgsql-general@lists.postgresql.org; Thu, 24 Apr 2025 05:10:04 +0000 Received: by mail-yw1-x1129.google.com with SMTP id 00721157ae682-6ff0c9d1761so7161817b3.1 for ; Wed, 23 Apr 2025 22:10:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745471401; x=1746076201; 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=xdo8oFa1ZdQc3LPj5pKkS0dIkSHvtJCXvTMxBuAkwTk=; b=FkshMlsKR3fXCmK0lPRF00iE0aEbL5yGNXK/bmH2jHNgkLi3UnuM7CVpImXKSrGaSz c5x7FhudLq93k4Y4OgnTYCd2wtUB0cj/ElaQ/OvA7RjoDAfQqNs5G8bdwBX6KoZNwh91 vxRPCYq5tPRYrlslMVpU4i/g+HoWOVxMJlWp6E6qCuqUX8Xa3uYP65XHxPa3kJLAUrwY gWRK4l9G3DAvJmdyCgO79dEj58KNoG27gXRCCfoKmWnwK66z9LVAme+GxHc6qN0U/+wp nBBxiA/uznwtL9JKGAIq2XWhGrqfs2y1PoflM33wROd6C3P/3L4sExQ9XI1pjRFCOKt8 5FEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745471401; x=1746076201; 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=xdo8oFa1ZdQc3LPj5pKkS0dIkSHvtJCXvTMxBuAkwTk=; b=ntPAW7cHYHqIJuxzljSTCnBzZUvg3WxQRX64s2JbUlaNfbWNkRLNbfEoMxT0Ue/Vx1 ih1GmFyO6KGfYeWMzf3XvoyavQmhRm9B/3R3kJxazNCliwEfPqYusQAOy6svYuVCZ/iI TdoqmjxFJJlRa6xWZUCgAiSvY6hFaogH4PE3WwwKa6B2Jlz8e+JRX5PErdx9t1i2vktJ d974Vbbtsln2gFGsop4uG5N+Q/xQj6SE/DhuOMMYh1jbYOGPyFkinWVX3rEhJ8h56LEq X2FqXffA4UQ0snUXoKTxfrqiX5Cmj7xGe/lH3jzxJeZY/eS8DDUypPLxj0/awAcBVi0u MgFQ== X-Forwarded-Encrypted: i=1; AJvYcCUCjS396uHT6U2a7j5SSTsnbXRtU2YDqtNI11gcREMviyUb1ds59buVk9x4uO8raCJrF9YREcOVn4HUf5MO@lists.postgresql.org X-Gm-Message-State: AOJu0YzEAmTNtzJhgMGPhnUEhOqKg8mQwQZHxzpvh8YcMkXd65xs5uKJ Iog37F+2dr/Q00mpFXRr6q482wqxHZP12v7uuVirp4aHk7kN8qTjY2Rvi+MjtA4ByNYOtOBmT1H t1jJIrw3O88yNyY4bcMV0WiL9vKw= X-Gm-Gg: ASbGncso2v4vuVOEDkfiDG1h0TMTBxgRnd/rs7A2Ipp7DJgSEViymPhSfxt8Iliq4aJ GajJu7rj17b92U4bizAABxN9vPj6hO9e0wYpY2mwZP8C8r8TJz9H5EK+wljmSsmm03AyxbRb44c CrmFEcKA/JPbk7/WBRBkFMH824l5lqNnT6cXXr9vxf/FU44c0Wfw6FMWY= X-Google-Smtp-Source: AGHT+IG0K22zIM3aOGaALoIEcMV1UWO6JvS32WXQUyycQDb80J9Tuj3nycBtFcJ24A+kQKO9+lzXXNb+bIrP7QZYcEM= X-Received: by 2002:a05:690c:dd3:b0:6fd:3d37:99ce with SMTP id 00721157ae682-7083ec82ac7mr20289867b3.17.1745471400901; Wed, 23 Apr 2025 22:10:00 -0700 (PDT) MIME-Version: 1.0 References: <03763b6b43cfd8a7194c2fb06452178db4256494.camel@cybertec.at> <4B9E0CAC-FB06-4F35-8C77-33AEA7F741B7@yesql.se> <1430373.1745432896@sss.pgh.pa.us> <1431982.1745433654@sss.pgh.pa.us> In-Reply-To: <1431982.1745433654@sss.pgh.pa.us> From: Igor Korot Date: Thu, 24 Apr 2025 00:09:49 -0500 X-Gm-Features: ATxdqUGJeW3NF3MD81qv7_uy1yB_o6uHuciu8Fo_gVKbKIGg2xWebrQjTc1tTDg Message-ID: Subject: Re: Another documentation issue To: Tom Lane Cc: Daniel Gustafsson , Laurenz Albe , "pgsql-generallists.postgresql.org" 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 Tom, On Wed, Apr 23, 2025 at 1:40=E2=80=AFPM Tom Lane wrote: > > Igor Korot writes: > > On Wed, Apr 23, 2025 at 1:28=E2=80=AFPM Tom Lane wr= ote: > >> If we do anything about this, I'd just say "systems that have > >> posix_fadvise()". If we write something more specific it's likely to > >> become obsolete, and it doesn't seem to me that it's hard for someone > >> to research "does my box have posix_fadvise()? > > > Imagine a person that wants to write a program which will cover creatin= g > > the table space. > > Such person needs to cover the appropriate fields with possible values. > > Is there a #define such person should check to cover the appropriate va= lues? > > HAVE_POSIX_FADVISE. Seems to me it'd be way easier to find that > from documentation that mentions posix_fadvise than from documentation > that says "it works on systems X, Y, Z". Most of the time the client and server are located on different machines. So there is no way to identify what server is supporting. How do you handle sch situation from the client POV? Thank you. > > regards, tom lane