From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
---|---|
To: | Jim Hines <jhines(at)wdtv(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: row size limitation |
Date: | 2001-01-18 18:00:34 |
Message-ID: | 3A672F42.168D0271@wgcr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Jim Hines wrote:
>
> We too just got bit by the row size limit, having installed from the
> rpms, 7.03.
>
> A news story wouldn't fit, and had to be drastically trimmed before it
> was
> accepted.
>
> Is there a way to reset this to say 32k, after the install, or is this
> a compile
> time option?
Compile-time. Before doing this, you must dump your database, as you
will have to re-initdb for the larger BLCKSIZ to work. See the file
config.h.in in src/include in the source dist (although the recommended
method of patching this is to run configure FIRST, then patch config.h
rather than config.h.in). Search fot BLCKSIZ in this file -- note that
32768 is the absolutely LARGEST BLCKSIZ you can have.
Or just wait on 7.1final, as 7.1 does away with the whole blocksize
limit entirely.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-18 18:08:17 | Re: VACUUM warning/error (?) |
Previous Message | mike | 2001-01-18 16:20:40 | 7.1 initdb error |