Re: Extending to 32K row limit - Mailing list pgsql-hackers

From Thomas Swan
Subject Re: Extending to 32K row limit
Date
Msg-id 5.0.0.11.2.20000808122512.01b072c8@sunset.backbone.olemiss.edu
Whole thread Raw
In response to Extending to 32K row limit  ("G. Anthony Reina" <reina@nsi.edu>)
List pgsql-hackers
At 12:24 PM 8/8/2000, G. Anthony Reina wrote:<br /><blockquote cite="cite" type="cite">I know that I've seen this
answerbefore but can't seem to find it for<br /> 7.0.2 in the archives. Which file(s) need to be changed to have
Postgres<br/> default to 32K size row limits rather than 8K? Has anyone run into any<br /> horror stories after going
to32K?<br /></blockquote><br /> I've been running it for a while and fairly heavily without any problems...<br /><br />
insrc/include/config.h modify the following section AFTER running configure.<br /><br /> /*<br />  * Size of a disk
block--- currently, this limits the size of a tuple.<br />  * You can set it bigger if you need bigger tuples.<br />
 */<br/> /* currently must be <= 32k bjm */<br /> #define BLCKSZ  8192<br /><br /> change to <br /><br /> #define
BLCKSZ 32768<br /><br />  This has worked for me....<br /> - <br /> - <b><u>Thomas Swan</u></b>
                                  <br/> - Graduate Student  - Computer Science<br /> - The University of Mississippi<br
/>- <br /> - "People can be categorized into two fundamental <br /> - groups, those that divide people into two groups
<br/> - and those that don't." 

pgsql-hackers by date:

Previous
From: "G. Anthony Reina"
Date:
Subject: Extending to 32K row limit
Next
From: Don Baccus
Date:
Subject: Re: Extending to 32K row limit