Re: Extending to 32K row limit

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: Thomas Swan <tswan(at)olemiss(dot)edu>, "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Extending to 32K row limit
Date: 2000-08-08 22:49:49
Message-ID: 39908E8D.B73A58DB@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas,

I've re-done my database with the 32K tuple limit-- looks good.
However, I seem to be having trouble with binary cursors. I think it may
be with the number of bytes in the tuple header (used to be 16 bytes
with the 8K limit). I've tried 16, 32, and 64, but haven't seemed to
find it. Have you used binary cursors with this setup?

Thanks.
-Tony

Thomas Swan wrote:

> At 12:24 PM 8/8/2000, G. Anthony Reina wrote:
>
>> I know that I've seen this answer before but can't seem to find it
>> for
>> 7.0.2 in the archives. Which file(s) need to be changed to have
>> Postgres
>> default to 32K size row limits rather than 8K? Has anyone run into
>> any
>> horror stories after going to 32K?
>
>
> I've been running it for a while and fairly heavily without any
> problems...
>
> in src/include/config.h modify the following section AFTER running
> configure.
>
> /*
> * Size of a disk block --- currently, this limits the size of a
> tuple.
> * You can set it bigger if you need bigger tuples.
> */
> /* currently must be <= 32k bjm */
> #define BLCKSZ 8192
>
> change to
>
> #define BLCKSZ 32768
>
> This has worked for me....
> -
> - Thomas Swan
> - Graduate Student - Computer Science
> - The University of Mississippi
> -
> - "People can be categorized into two fundamental
> - groups, those that divide people into two groups
> - and those that don't."

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message G. Anthony Reina 2000-08-08 22:57:44 Re: Extending to 32K row limit
Previous Message Kaare Rasmussen 2000-08-08 20:03:11 Arrays and foreign keys