Re: [HACKERS] 8K block limit

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: [HACKERS] 8K block limit
Дата
Msg-id 199902171359.WAA01937@ext16.sra.co.jp
обсуждение исходный текст
Ответ на Re: [HACKERS] 8K block limit  (Peter T Mount <peter@retep.org.uk>)
Ответы Re: [HACKERS] 8K block limit  (Peter T Mount <peter@taer.maidstone.gov.uk>)
Список pgsql-hackers
> 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?
---
Tatsuo Ishii


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

Предыдущее
От: "jose' soares"
Дата:
Сообщение: varchar function
Следующее
От: Horak Daniel
Дата:
Сообщение: interface between backend and dynamicly loaded modules