Re: Tablespace-level Block Size Definitions - Mailing list pgsql-hackers

From Bricklen Anderson
Subject Re: Tablespace-level Block Size Definitions
Date
Msg-id 429CD099.5020804@PresiNET.com
Whole thread Raw
In response to Tablespace-level Block Size Definitions  ("Jonah H. Harris" <jharris@tvi.edu>)
Responses Re: Tablespace-level Block Size Definitions
List pgsql-hackers
Jonah H. Harris wrote:
> Hey everyone,
> 
> I'm sure this has been thought of but was wondering whether anyone had 
> discussed the allowance of run-time block size specifications at the 
> tablespace level?  I know that a change such as this would substantially 
> impact buffer operations, transactions, access methods, the storage 
> manager, and a lot of other stuff, however it would give an 
> administrator the ability to inhance performance for specific applications.
> 
> Arguably, one can set the block size at compile-time, but for a system 
> running multiple databases it *may* be a nice feature.  Would it be used 
> a lot?  Probably not.  Would I use it?  Certainly!  Would some of my 
> clients use it?  Yes.
> 
> Perhaps a TODO item for some advantageous company to fund?
> 
> -Jonah

Have you used Oracle's version as well?

-- 
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Tablespace-level Block Size Definitions
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Deadlock with tsearch2 index ...