| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | <shridhar_daithankar(at)persistent(dot)co(dot)in>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Page Size in Future Releases |
| Date: | 2003-03-21 03:51:51 |
| Message-ID: | 08ac01c2ef5d$3487fec0$6500a8c0@fhp.internal |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-03-21 04:03:41 | Re: Page Size in Future Releases |
| Previous Message | Shridhar Daithankar<shridhar_daithankar@persistent.co.in> | 2003-03-21 03:48:54 | Re: postgresql meltdown on PlanetMath.org |