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

From Mario Weilguni
Subject Re: Page Size in Future Releases
Date
Msg-id 200303230946.41441.mweilguni@sime.com
Whole thread Raw
In response to Re: Page Size in Future Releases  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Am Samstag, 22. März 2003 01:15 schrieb Tom Lane:
> "Kendrick C. Wilson" <kendrick_wilson@hotmail.com> writes:
> > Will a increase in the size of a data page increase performance of a
> > database with large records?
>
> Probably not; in fact the increased WAL overhead could make it a net
> loss.  But feel free to try changing BLCKSZ to see how it works for you.

I've several database with 32KB and 8KB, and though the results are not really comparable due to slight different
hardware,I've the feeling that 8KB buffers work best in most cases. The only difference I noticed are large objects
whichseem to work slightly better with larger sizes. 

Regards,
    Mario Weilguni


pgsql-performance by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: Make PGSQL faster
Next
From: bsamwel@xs4all.nl
Date:
Subject: Slow update of indexed column with many nulls