Re: Tablespace-level Block Size Definitions

From: Bricklen Anderson <BAnderson(at)PresiNET(dot)com>
To: "Jonah H(dot) Harris" <jharris(at)tvi(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tablespace-level Block Size Definitions
Date: 2005-05-31 21:01:13
Message-ID: 429CD099.5020804@PresiNET.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
_______________________________

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-05-31 21:01:47 Re: Deadlock with tsearch2 index ...
Previous Message Jonah H. Harris 2005-05-31 20:55:29 Tablespace-level Block Size Definitions