Re: Page Size in Future Releases - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Page Size in Future Releases
Date
Msg-id 08ac01c2ef5d$3487fec0$6500a8c0@fhp.internal
Whole thread Raw
In response to Page Size in Future Releases  ("Kendrick C. Wilson" <kendrick_wilson@hotmail.com>)
List pgsql-performance
> > I have records about 881 byte + 40 byte (header) = 921.
> >
> > 8k page size / 921 bytes per record is ONLY 8 records...........
>
> You can tweak it yourself at compile time in some header file and that
should
> work but that is a point of diminising results as far as hackers are
> concerned.

As far as I'm aware the 8k page size has nothing to do with speed and
everything to do with atomic writes.  You can't be guaranteed that the O/S
and hard drive controller will write anything more than 8K in an atomic
block...

Chris


pgsql-performance by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: postgresql meltdown on PlanetMath.org
Next
From: Josh Berkus
Date:
Subject: Re: Page Size in Future Releases