Re: [HACKERS] 8K block limit - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [HACKERS] 8K block limit
Date
Msg-id 199902171359.WAA01937@ext16.sra.co.jp
Whole thread Raw
In response to Re: [HACKERS] 8K block limit  (Peter T Mount <peter@retep.org.uk>)
Responses Re: [HACKERS] 8K block limit
List 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 by date:

Previous
From: "jose' soares"
Date:
Subject: varchar function
Next
From: Horak Daniel
Date:
Subject: interface between backend and dynamicly loaded modules