From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
Cc: | mladen(dot)gogala(at)vmsinfo(dot)com, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Asynchronous I/O in Postgres |
Date: | 2010-10-21 02:30:22 |
Message-ID: | 201010210230.o9L2UMX11996@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-novice |
Josh Kupershmidt wrote:
> On Fri, Oct 8, 2010 at 8:14 AM, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)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.htm>
> 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-10-21 21:29:11 | Re: Gripe: bytea_output default => data corruption |
Previous Message | Tom Lane | 2010-10-20 21:07:29 | Re: Inaccurate comment for information_schema.triggered_update_columns |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-21 02:36:11 | Re: "duplicate key value": version 8.4 vs 8.1 |
Previous Message | Turner, John J | 2010-10-21 02:04:17 | source make check regression test on windows xp |