pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ken Mort <kenmort@mort.port.net>
To: pgsql-sql@postgreSQL.org
Cc: edmund@wildworld.net
Subject: Re: [SQL] 8K limit ...
Date: Mon, 23 Feb 1999 21:58:36 -0500
Message-ID: <199902240300.WAA05213@astor.interport.net> (raw)
In-Reply-To: <36D25790.DB4B1EEF@wildworld.net>

I just asked this recently. Had to go to the hackers list to ask. They
said it could be changed at compile time. Here is their reply.

> > 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)

I haven't done it yet but I found a define for 'BLCKSZ' in:
src/include/config.h
which is set to 8192. This should probably be changed to 32K
or more specifically 32768 for 32K block size.
My post generated some comments, speculation and tests in the
hackers list so you may want to look at the archives for that list
starting feb 15, 1999.

> I'm using PostgreSQL 6.3.2.  It seems that PostgreSQL has a record size
> of 8 K..
> 
> My problem is that I have some records that contain a  text field called
> DESCRIPTION.  Some of these descriptions will be in excess of 25K.
> 
> Someone on another list said that there is a way to compile the newer
> versions of POSTGRESQL to allow larger block sizes.
> 
> Of course the person hasn't bothered answering my question as to where
> this information is other than look in the docs.  Well, I have looked in
> the docs and I can't find it anywhere.
> 
> Does anyone know how to compile POSTGRESQL for these larger blocks or
> would I just be better off using MySQL?


Regards,
Kenneth R. Mort  <kenmort@mort.port.net>
TreeTop Research
Brooklyn, NY, USA



view thread (2+ messages)

Message-ID: <199902240300.WAA05213@astor.interport.net>
Permalink:  ../199902240300.WAA05213@astor.interport.net/
Also on:    postgresql.org/message-id/199902240300.WAA05213@astor.interport.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: kenmort@mort.port.net, edmund@wildworld.net
  Subject: Re: [SQL] 8K limit ...
  In-Reply-To: <199902240300.WAA05213@astor.interport.net>
  References: <36D25790.DB4B1EEF@wildworld.net> <199902240300.WAA05213@astor.interport.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox