From: Bruce Momjian <bruce@momjian.us>
To: Josh Kupershmidt <schmiddy@gmail.com>
Cc: mladen.gogala@vmsinfo.com, "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Subject: Re: Asynchronous I/O in Postgres
Date: Wed, 20 Oct 2010 22:30:22 -0400 (EDT)
Message-ID: <201010210230.o9L2UMX11996@momjian.us> (raw)
In-Reply-To: <AANLkTinygXJv_CFY__PT+hQYWMADC6bDrMQih-kk2wbd@mail.gmail.com>
Josh Kupershmidt wrote:
> On Fri, Oct 8, 2010 at 8:14 AM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:
> > Mladen Gogala wrote:
> >>
> >> So, essentially, the process is reading block by block, in a sequence.
> >> What, exactly, does "effective_io_concurrency" mean?
> >>
> >
> > To rephrase my question, can anybody tell me where in the code is it used?
>
> The docs are a bit sparse here :-(
>
> But it looks to me like effective_io_concurrency only affects bitmap
> heap scans. The setting from effective_io_concurrency gets put into
> "target_prefetch_pages" in ./src/backend/utils/misc/guc.c . But the
> only place which uses that variable is
> ./src/backend/executor/nodeBitmapHeapscan.c.
>
> The EnterpriseDB docs
> <http://www.enterprisedb.com/docs/en/8.3R2/perf/Postgres_Plus_Advanced_Server_Performance_Guide-17.ht...;
> mention:
> "effective_io_concurrency is only used for Bitmap Heap Scans. For
> normal sequential scans the operating system should handle read-ahead
> internally (On Linux, see the blockdev command, in particular --setra
> and --setfra)."
So, this this also true for community Postgres? Can someone suggest
updated docs?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
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: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, schmiddy@gmail.com, pgsql-novice@postgresql.org
Subject: Re: Asynchronous I/O in Postgres
In-Reply-To: <201010210230.o9L2UMX11996@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox