Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Page Size in Future Releases
Date
Msg-id 16704.1048292123@sss.pgh.pa.us
Whole thread Raw
In response to Page Size in Future Releases  ("Kendrick C. Wilson" <kendrick_wilson@hotmail.com>)
Responses Re: Page Size in Future Releases  (Mario Weilguni <mweilguni@sime.com>)
List pgsql-performance
Tree view 
"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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql meltdown on PlanetMath.org
Next
From: Andrew McMillan
Date:
Subject: Re: Make PGSQL faster