MIME-Version: 1.0
References: <CA+FnnTxPHoCZz2JBFxC3Wdsce9KUwNL0KcH5Ua37R55XLQbrpg@mail.gmail.com>
 <03763b6b43cfd8a7194c2fb06452178db4256494.camel@cybertec.at>
In-Reply-To: <03763b6b43cfd8a7194c2fb06452178db4256494.camel@cybertec.at>
From: Igor Korot <ikorot01@gmail.com>
Date: Thu, 24 Apr 2025 00:26:47 -0500
Message-ID: <CA+FnnTyYNuO3X-UX3fjugATh7Eew8v4SLeHmnLqnBzRgJGUprg@mail.gmail.com>
Subject: Re: Another documentation issue
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTyYNuO3X-UX3fjugATh7Eew8v4SLeHmnLqnBzRgJGUprg%40mail.gmail.com>
Precedence: bulk

Hi, Laurenz,

On Wed, Apr 23, 2025 at 2:16=E2=80=AFAM Laurenz Albe <laurenz.albe@cybertec=
.at> wrote:
>
> On Wed, 2025-04-23 at 00:21 -0500, Igor Korot wrote:
> > On the page https://www.postgresql.org/docs/current/runtime-config-quer=
y.html#GUC-SEQ-PAGE-COST
> >
> > it is only given the default value of this parameter.
> >
> > No min/max values are provided..
> >
> > The same can be sad about
> > https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-R=
ANDOM-PAGE-COST
>
> Sad.  But you can interpret it as "there is no maximum".  The actual maxi=
mum is DBL_MAX,
> the biggest double precision value that your system can handle, and may d=
epend on your
> architecture.

So if I want to execute it from the client code (whether ODBC based or
libpq based),
how do I handle it?

Because most of the time client and server are located on different machine=
s...

Thank you.


>
> > However, this page
> > https://www.postgresql.org/docs/current/runtime-config-resource.html#GU=
C-EFFECTIVE-IO-CONCURRENCY
> > describes both default and mn/max, however t s says:
> >
> > [quote]
> > The default is 1 on supported systems, otherwise 0
> > [/quote]]
> >
> > No explanation of what is "supported system" is given...
> >
> > And the same can be said about
> > https://www.postgresql.org/docs/current/runtime-config-resource.html#GU=
C-MAINTENANCE-IO-CONCURRENCY.
>
> According to the source, it is "systems that have posix_fadvise()".  We c=
ould document that,
> but I don't know if it would help many people.  I am not sure how easy an=
d feasible it is
> to research which versions of which operating systems qualify.
>
> Yours,
> Laurenz Albe