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

From Peter T Mount
Subject Re: [HACKERS] 8K block limit
Date
Msg-id Pine.LNX.4.04.9902162014291.29227-100000@maidast.retep.org.uk
Whole thread Raw
In response to 8K block limit  ("Ken Mort" <kenmort@mort.port.net>)
Responses Re: [HACKERS] 8K block limit  (Tatsuo Ishii <t-ishii@sra.co.jp>)
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).

Note: Changing the block size may have a performance hit however.

Another way is to break the polygons down into smaller pieces.

Peter

--      Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf



pgsql-hackers by date:

Previous
From: "Randy Singh"
Date:
Subject: Help for running initdb
Next
From: Mohamed Salah-Al-Din Hefny
Date:
Subject: Problem in Compiling