I was unclear on this, although I think the answer below is correct for my
real question. Let me ask this question again...
What is the current size limit for a single row (say for type TEXT or
VARCHAR)? When is this expected to go away (7.1?)?
Is the info below accurate? Am I limited to 32k (if I rebuild)?
Thanks,
--Rainer
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Serge Canizares
Sent: Wednesday, December 20, 2000 12:18 AM
To: Rainer Mager
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] SQL statement limit
If I understand your question, you can change this limit, but not to 200k.
By default, the data limit in a field record is 8k in the PostgreSQL 7.0x
series.
You can make it 16k or 32k.
Go into the src/include subdir of whatever directory you extracted the
tarball into.
Before compiling, edit the file called "config.h.in".
Change the line from
#define BLCKSZ 8192
to
#define BLCKSZ 32768
(for 32k limit).
-Serge