RE: 8192 BLCKSZ ?] - Mailing list pgsql-hackers

From Andrew Snow
Subject RE: 8192 BLCKSZ ?]
Date
Msg-id JEEGIJPOJIGGIIHGKOKOEELCCFAA.andrew@modulus.org
Whole thread Raw
In response to Re: [Fwd: Re: 8192 BLCKSZ ?]  (mlw <markw@mohawksoft.com>)
Responses RE: 8192 BLCKSZ ?]
List pgsql-hackers

> The cost difference between 32K vs 8K disk reads/writes are so small
> these days when compared with overall cost of the disk operation itself,
> that you can even measure it, well below 1%. Remember seek times
> advertised on disks are an average.

It has been said how small the difference is - therefore in my opinion it
should remain at 8KB to maintain best average performance with all existing
platforms.

I say its best let the OS and mass storage subsystem worry about read-ahead
caching and whether they actually read 8KB off the disk, or 32KB or 64KB
when we ask for 8.


- Andrew




pgsql-hackers by date:

Previous
From: anuradha
Date:
Subject: pg_ident.conf
Next
From: "Andrew Snow"
Date:
Subject: RE: SQL 'in' vs join.