MIME-Version: 1.0
References: <CA+FnnTxPHoCZz2JBFxC3Wdsce9KUwNL0KcH5Ua37R55XLQbrpg@mail.gmail.com>
 <03763b6b43cfd8a7194c2fb06452178db4256494.camel@cybertec.at>
 <4B9E0CAC-FB06-4F35-8C77-33AEA7F741B7@yesql.se> <1430373.1745432896@sss.pgh.pa.us>
In-Reply-To: <1430373.1745432896@sss.pgh.pa.us>
From: Igor Korot <ikorot01@gmail.com>
Date: Wed, 23 Apr 2025 13:32:50 -0500
Message-ID: <CA+FnnTz5tbFf_sHmfkGQZTquxDDgdfq5UVmh0gCSQGPbtoT0vw@mail.gmail.com>
Subject: Re: Another documentation issue
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Daniel Gustafsson <daniel@yesql.se>, Laurenz Albe <laurenz.albe@cybertec.at>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cbed2306337654ea"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTz5tbFf_sHmfkGQZTquxDDgdfq5UVmh0gCSQGPbtoT0vw%40mail.gmail.com>
Precedence: bulk

--000000000000cbed2306337654ea
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi, Tom,

On Wed, Apr 23, 2025 at 1:28=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Daniel Gustafsson <daniel@yesql.se> writes:
> >> On 23 Apr 2025, at 09:16, Laurenz Albe <laurenz.albe@cybertec.at>
> wrote:
> >> On Wed, 2025-04-23 at 00:21 -0500, Igor Korot wrote:
> >>> No explanation of what is "supported system" is given...
>
> >> According to the source, it is "systems that have posix_fadvise()".  W=
e
> could 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.
>
> >> From memory it's supported on FreeBSD, NetBSD and Linux with Windows,
> macOS and
> > OpenBSD not supporting it.  Assuming I'm not completely wrong (a 1 minu=
te
> > search shows it's in the ballpark) we could perhaps add something like
> > "Unsupported platforms include (but isn't limited to) Windows and macOS=
"
> which
> > would provide a bit more clarity.
>
> 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 creating
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 values=
?

Thank you?

".
>
>                         regards, tom lane
>

--000000000000cbed2306337654ea
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi, Tom,</div><div><br><div class=3D"gmail_quote gmail_qu=
ote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Apr 23, 2025 a=
t 1:28=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss=
.pgh.pa.us</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Daniel G=
ustafsson &lt;<a href=3D"mailto:daniel@yesql.se" target=3D"_blank">daniel@y=
esql.se</a>&gt; writes:<br>
&gt;&gt; On 23 Apr 2025, at 09:16, Laurenz Albe &lt;<a href=3D"mailto:laure=
nz.albe@cybertec.at" target=3D"_blank">laurenz.albe@cybertec.at</a>&gt; wro=
te:<br>
&gt;&gt; On Wed, 2025-04-23 at 00:21 -0500, Igor Korot wrote:<br>
&gt;&gt;&gt; No explanation of what is &quot;supported system&quot; is give=
n...<br>
<br>
&gt;&gt; According to the source, it is &quot;systems that have posix_fadvi=
se()&quot;.=C2=A0 We could document that,<br>
&gt;&gt; but I don&#39;t know if it would help many people.=C2=A0 I am not =
sure how easy and feasible it is<br>
&gt;&gt; to research which versions of which operating systems qualify.<br>
<br>
&gt;&gt; From memory it&#39;s supported on FreeBSD, NetBSD and Linux with W=
indows, macOS and<br>
&gt; OpenBSD not supporting it.=C2=A0 Assuming I&#39;m not completely wrong=
 (a 1 minute<br>
&gt; search shows it&#39;s in the ballpark) we could perhaps add something =
like<br>
&gt; &quot;Unsupported platforms include (but isn&#39;t limited to) Windows=
 and macOS&quot; which<br>
&gt; would provide a bit more clarity.<br>
<br>
If we do anything about this, I&#39;d just say &quot;systems that have<br>
posix_fadvise()&quot;.=C2=A0 If we write something more specific it&#39;s l=
ikely to<br>
become obsolete, and it doesn&#39;t seem to me that it&#39;s hard for someo=
ne<br>
to research &quot;does my box have posix_fadvise()?</blockquote><div dir=3D=
"auto"><br></div><div dir=3D"auto">Imagine a person that wants to write a p=
rogram which will cover creating the table space.</div><div dir=3D"auto"><b=
r></div><div dir=3D"auto">Such person needs to cover the appropriate fields=
 with possible values.</div><div dir=3D"auto"><br></div><div dir=3D"auto">I=
s there a #define such person should check to cover the appropriate values?=
</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thank you?</div><div di=
r=3D"auto"><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 =
0 .8ex;border-left:1px #ccc solid;padding-left:1ex" dir=3D"auto">&quot;.<br=
>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div></div>

--000000000000cbed2306337654ea--