Skip site navigation (1) Skip section navigation (2)

Re: Increasing row size beyond 8k

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mitch Vincent" <mitch(at)venux(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Increasing row size beyond 8k
Date: 2000-05-29 03:54:59
Message-ID: 4105.959572499@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"Mitch Vincent" <mitch(at)venux(dot)net> writes:
>     There was some talk a while back of changing the blocksize to 32k in
> order to increase possible row size, I need to do this (and don't want to
> screw anything up) but am unsure about how to go about it.. Is BLKSZ (if
> that's even correct) simply a PG variable somewhere?

It's near the head of src/include/config.h (or config.h.in if you
are doing the edit before running configure).  Edit, rebuild the
system, away you go.  Don't forget you will need to initdb after
installing the rebuilt postmaster...

> That sounds like what I'm looking for and since it's set to 8k, looks like
> what I'm looking for -- so would I be correct in changing this value and
> re-compiling my kernel?

No no no, do not touch your kernel.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-05-29 04:12:49
Subject: Re: Probably already asked but
Previous:From: The Hermit HackerDate: 2000-05-29 03:29:59
Subject: Re: Probably already asked but

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group