From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: BLCKSZ
Date: Tue, 6 Dec 2005 11:59:35 +0100
Message-ID: <20051206105935.GA21823@uio.no> (raw)
In-Reply-To: <43956AAF.7060108@mail.ru>
References: <dn1gdd$19kg$1@news.hub.org>
<29518.1133794958@sss.pgh.pa.us>
<4394B1D3.7000304@mail.ru>
<6.2.5.6.0.20051205183120.01dd6a80@earthlink.net>
<43956AAF.7060108@mail.ru>
On Tue, Dec 06, 2005 at 01:40:47PM +0300, Olleg wrote:
> I can't undestand why "bigger is better". For instance in search by
> index. Index point to page and I need load page to get one row. Thus I
> load 8kb from disk for every raw. And keep it then in cache. You
> recommend 64kb. With your recomendation I'll get 8 times more IO
> throughput, 8 time more head seek on disk, 8 time more memory cache (OS
> cache and postgresql) become busy.
Hopefully, you won't have eight times the seeking; a single block ought to be
in one chunk on disk. You're of course at your filesystem's mercy, though.
/* Steinar */
--
Homepage: http://www.sesse.net/
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: sgunderson@bigfoot.com
Subject: Re: BLCKSZ
In-Reply-To: <20051206105935.GA21823@uio.no>
* 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