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
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 |