public inbox for [email protected]  

help / color / mirror / Atom feed

From: Igor Korot <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Another documentation issue
Date: Thu, 24 Apr 2025 00:26:47 -0500
Message-ID: <CA+FnnTyYNuO3X-UX3fjugATh7Eew8v4SLeHmnLqnBzRgJGUprg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+FnnTxPHoCZz2JBFxC3Wdsce9KUwNL0KcH5Ua37R55XLQbrpg@mail.gmail.com>
	<[email protected]>

Hi, Laurenz,

On Wed, Apr 23, 2025 at 2:16 AM Laurenz Albe <[email protected]> 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

view thread (10+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Another documentation issue
  In-Reply-To: <CA+FnnTyYNuO3X-UX3fjugATh7Eew8v4SLeHmnLqnBzRgJGUprg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox