Skip site navigation (1) Skip section navigation (2)

RE: 8192 BLCKSZ ?]

From: "Andrew Snow" <andrew(at)modulus(dot)org>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: 8192 BLCKSZ ?]
Date: 2000-12-01 23:52:44
Message-ID: JEEGIJPOJIGGIIHGKOKOEELCCFAA.andrew@modulus.org (view raw or flat)
Thread:
Lists: 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



In response to

Responses

pgsql-hackers by date

Next:From: Michael ForkDate: 2000-12-02 00:24:05
Subject: ODBC Driver
Previous:From: Don BaccusDate: 2000-12-01 23:47:58
Subject: Re: COPY BINARY is broken...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group