From: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk> |
---|---|
To: | Aarmel <pgadmin(at)animated(dot)net(dot)au> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Max Tuple Size |
Date: | 2001-04-05 06:39:53 |
Message-ID: | Pine.GSO.4.21.0104050835570.1479-100000@borg.cs.auc.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Fri, 6 Apr 2001, Aarmel wrote:
> We want to insert text into a table. Large amounts of text.
>
> The limit on the version we have at the moment is around 9000 characters.
> I'd estimate we'd need to be able to insert around 20,000 to 50,000
> characters.
>
> Does Version 7.0.3 have a limit, is 7.1 the only version with no limit.
7.0.3 has a limit of 8KB by default. Version 7.1 does not have any limit.
>
> Are there confiuration settings in postgres to set a limit? or do I just
> have to use blobs and lobs :(
I wouldn't recommende blobs/lobs. You can recompile 7.0.3 with a BLOCKSIZE
of 32KB instead of 8KB or you can use version 7.1RC2 which you can find in
ftp://ftp.postgresql.org/pub/dev
The 7.1 Release Candidate 2 is quite stable.
HTH,
Poul L. Christiansen
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Velkov | 2001-04-05 08:22:35 | copy from multi-line text problem |
Previous Message | Tom Lane | 2001-04-05 02:31:24 | Re: Function not working check_foreign_key(). |