DB block size Vs filesystem buffer size

From: Shankar K <shan0075(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: DB block size Vs filesystem buffer size
Date: 2003-04-23 18:21:58
Message-ID: 20030423182158.51503.qmail@web21107.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi there,

below quote is from steve adams suggesting to have db
block size and filesystem buffer size of same size to
avoid io issues in oracle.

Will this have any effect on postgresql. we use linux
7.3 with ext3 where fs buffersize is 4k however
postgres default blocksize is 8k. any performance gain
in having both sizes same in postgresql.

thanks,
Shankar

<quote from ixora.com.au>
"If the database block size is larger than the file
system buffer size, then all single block reads and
writes are split into a series of distinct physical
I/O operations - one for each file system buffer
addressed - and these I/O operations are performed one
at a time. For writes, a full rotational latency is
sustained between each pair of file system buffer
writes. For reads, all except the initial file system
buffer read can normally be satisfied cheaply from the
disk track buffers. However, the distinct contiguous
file system buffer reads trigger the file system read
ahead mechanism, even for random reads, causing
inappropriate read ahead."
</quote>

__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-04-23 18:32:00 Re: upgrade problems
Previous Message Vikas 2003-04-23 18:15:36 After restoring a database using pg_restore , cannot insert or update records in tables with primary keys