Re: [HACKERS] 8K block limit

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Ken Mort <kenmort(at)mort(dot)port(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] 8K block limit
Date: 1999-02-16 20:16:34
Message-ID: Pine.LNX.4.04.9902162014291.29227-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mohamed Salah-Al-Din Hefny 1999-02-17 08:24:02 Problem in Compiling
Previous Message Thomas Reinke 1999-02-16 15:12:44 [Fwd: [HACKERS] JDBC lo crashes etc (fwd)]