Re: SQL statement limit - Mailing list pgsql-admin

From Serge Canizares
Subject Re: SQL statement limit
Date
Msg-id 002a01c069ce$df7e4df0$2eac9dc0@vespers
Whole thread Raw
In response to SQL statement limit  ("Rainer Mager" <rmager@vgkk.com>)
Responses RE: SQL statement limit  ("Rainer Mager" <rmager@vgkk.com>)
List pgsql-admin
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


> Oh yeah, also, is the limit changeable at compile time? If so, if we set
it
> to something like 200k, would that work?
>
> Thanks,
>
> --Rainer
>
>


pgsql-admin by date:

Previous
From: Ørjan Vøllestad
Date:
Subject: Dump a base from PostgreSQL 6.5.3 to PostgreSQL 7.0
Next
From: Mustafa Timur GÖKÇE
Date:
Subject: Large Object