Re: Another documentation issue

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Another documentation issue
Date: 2025-04-24 05:26:47
Message-ID: CA+FnnTyYNuO3X-UX3fjugATh7Eew8v4SLeHmnLqnBzRgJGUprg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, Laurenz,

On Wed, Apr 23, 2025 at 2:16 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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-query.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-RANDOM-PAGE-COST
>
> Sad. But you can interpret it as "there is no maximum". The actual maximum is DBL_MAX,
> the biggest double precision value that your system can handle, and may depend 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 machines...

Thank you.

>
> > 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:
> >
> > [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#GUC-MAINTENANCE-IO-CONCURRENCY.
>
> According to the source, it is "systems that have posix_fadvise()". We 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.
>
> Yours,
> Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2025-04-24 05:29:17 Re: Another documentation issue
Previous Message David G. Johnston 2025-04-24 05:23:39 Re: Another documentation issue