From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alex Turner <armtuk@gmail.com>
Cc: Pgsql-Performance ((E-mail)) <pgsql-performance@postgresql.org>
Subject: Re: Confusion and Questions about blocks read
Date: Fri, 22 Sep 2006 12:24:35 -0400
Message-ID: <780.1158942275@sss.pgh.pa.us> (raw)
In-Reply-To: <33c6269f0609220834x6c10db9xa40d6121825dfd14@mail.gmail.com>
References: <33c6269f0609220834x6c10db9xa40d6121825dfd14@mail.gmail.com>
"Alex Turner" <armtuk@gmail.com> writes:
> Home come the query statistics showed that 229066 blocks where read given
> that all the blocks in all the tables put together only total 122968?
You forgot to count the indexes. Also, the use of indexscans in the
mergejoins probably causes multiple re-reads of some table blocks,
depending on just what the physical ordering of the rows is.
regards, tom lane
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: tgl@sss.pgh.pa.us, armtuk@gmail.com
Subject: Re: Confusion and Questions about blocks read
In-Reply-To: <780.1158942275@sss.pgh.pa.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