Re: [HACKERS] 8K block limit

Поиск
Список
Период
Сортировка
От Peter T Mount
Тема Re: [HACKERS] 8K block limit
Дата
Msg-id Pine.LNX.4.04.9902171543110.19908-100000@taer.maidstone.gov.uk
обсуждение исходный текст
Ответ на Re: [HACKERS] 8K block limit  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Ответы Re: [HACKERS] 8K block limit  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
On Wed, 17 Feb 1999, Tatsuo Ishii wrote:

> > On Mon, 15 Feb 1999, Ken Mort wrote:
> > 
> > > Already asked this in the other lists so here.
> > > 
> > > I need to store some polygons that are larger than 8K.
> > > I was reading in hackers archives talk about a solution
> > > to the 8K limit. Was anything done? If so, what do I
> > > need to do to solve my problem?
> > 
> > There is an option that can be set at compile time to set the block size
> > from 8k to something like 32 or 64K (not sure which).
> 
> I think it is 32k. (tuple offset in a block is limited to 15 bits)
> 
> > Note: Changing the block size may have a performance hit however.
> 
> Why?

I think some file systems are more optimised for 8K blocks. I may be
thinking on the original reason for the 8k limit in the first place, but I
remember there was discussions about this when the block size was altered.

Peter

-- 
Peter Mount, IT Section
petermount@it.maidstone.gov.uk
Anything I write here are my own views, and cannot be taken as being the
official words of Maidstone Borough Council




В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] Is the int8_ops being implimented?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] 8K block limit