| From: | Thomas Swan <tswan(at)olemiss(dot)edu> |
|---|---|
| To: | "G(dot) Anthony Reina" <reina(at)nsi(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 17:26:37 |
| Message-ID: | 5.0.0.11.2.20000808122512.01b072c8@sunset.backbone.olemiss.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Baccus | 2000-08-08 17:27:53 | Re: Re: [GENERAL] Trouble with float4 afterupgrading from 6.5.3 to 7.0.2 |
| Previous Message | G. Anthony Reina | 2000-08-08 17:24:43 | Extending to 32K row limit |