AW: 8192 BLCKSZ ? - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: 8192 BLCKSZ ?
Date
Msg-id 11C1E6749A55D411A9670001FA68796336814A@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> I don't believe it's a performance issue, I believe it's that 
> writes to
> blocks greater than 8k cannot be guaranteed 'atomic' by the operating
> system.  Hence, 32k blocks would break the transactions system.  (Or
> something like that - am I correct?)

First, 8k are not atomic eighter. Second, the page layout in PostgreSQL has been
designed to not care about the atomicity of IO. This design might have been 
compromised for index pages recently, to optimize index performance, 
but data pages are perfectly safe.

Andreas


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Full text Indexing -out of contrib and into main..
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: 8192 BLCKSZ ?