From: Michael Stone <mstone+postgres@mathom.us>
To: John A Meinel <john@arbash-meinel.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: read block size
Date: Tue, 28 Jun 2005 13:27:01 -0400
Message-ID: <20050628172701.GW9591@mathom.us> (raw)
In-Reply-To: <42C182BF.1050808@arbash-meinel.com>
References: <20050628152750.GV9591@mathom.us>
<42C182BF.1050808@arbash-meinel.com>
On Tue, Jun 28, 2005 at 12:02:55PM -0500, John A Meinel wrote:
>There has been discussion about changing the reading/writing code to be
>able to handle multiple pages at once, (using something like vread())
>but I don't know that it has been implemented.
that sounds promising
>Also, this would hurt cases where you can terminate as sequential scan
>early.
If you're doing a sequential scan of a 10G file in, say, 1M blocks I
don't think the performance difference of reading a couple of blocks
unnecessarily is going to matter.
>And if the OS is doing it's job right, it will already do some
>read-ahead for you.
The app should have a much better idea of whether it's doing a
sequential scan and won't be confused by concurrent activity. Even if
the OS does readahead perfectly, you'll still get a with with larger
blocks by cutting down on the syscalls.
Mike Stone
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-performance@postgresql.org
Cc: mstone+postgres@mathom.us, john@arbash-meinel.com
Subject: Re: read block size
In-Reply-To: <20050628172701.GW9591@mathom.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