Re: Bumping block size to 16K on FreeBSD... - Mailing list pgsql-hackers

From Thomas Swan
Subject Re: Bumping block size to 16K on FreeBSD...
Date
Msg-id 3F4E6174.8090102@idigx.com
Whole thread Raw
In response to Re: Bumping block size to 16K on FreeBSD...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bumping block size to 16K on FreeBSD...
List pgsql-hackers
Tom Lane wrote:

>Sean Chittenden <sean@chittenden.org> writes:
>  
>
>>Are there any objections
>>to me increasing the block size for FreeBSD installations to 16K for
>>the upcoming 7.4 release?
>>    
>>
>
>I'm a little uncomfortable with introducing a cross-platform variation
>in the standard block size.  That would have implications for things
>like whether a table definition that works on FreeBSD could be expected
>to work elsewhere; to say nothing of recommendations for shared_buffer
>settings and suchlike.
>
>Also, there is no infrastructure for adjusting BLCKSZ automatically at
>configure time, and I don't much want to add it.
>  
>
Has anyone looked at changing the default block size across the board
and what the performance improvements/penalties might be?  Hardware has
changed quite a bit over the years.



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: New array functions
Next
From: Greg Stark
Date:
Subject: Re: bug with constraint dependencies? or bug with