"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 Lane||Date: 2000-05-29 04:12:49|
|Subject: Re: Probably already asked but |
|Previous:||From: The Hermit Hacker||Date: 2000-05-29 03:29:59|
|Subject: Re: Probably already asked but|