Re: does the' text' type cann't store more than 20,000char ? - Mailing list pgsql-sql

From Mitch Vincent
Subject Re: does the' text' type cann't store more than 20,000char ?
Date
Msg-id 003501bfcaa2$8d52f4c0$0300000a@doot.org
Whole thread Raw
In response to does the' text' type cann't store more than 20,000char ?  ("xu hai" <xvhai@21cn.com>)
List pgsql-sql
It can't be any larger than 8k (minus a bit of overhead). You can increase
this now to 32k (again, minus the same overhead) by changing BLKSZ to 32k in
the config.h header..

I'm successfully doing this in my database (which is pretty high-traffic and
pretty large).

Good luck!

-Mitch
----- Original Message -----
From: xu hai <xvhai@21cn.com>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, May 30, 2000 9:11 PM
Subject: [SQL] does the' text' type cann't store more than 20,000char ?


> hi .everyine
>     when i want put a long file into a field  with text type . i was
warning the turple is
> too long  and the table cann't open again.does the' text'  type cann't
store more than  about 9,050 char ?
>     thank you .
>                             xv hai
>



pgsql-sql by date:

Previous
From: "xu hai"
Date:
Subject: does the' text' type cann't store more than 20,000char ?
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Re: aliases break my query