Skip site navigation (1) Skip section navigation (2)

Re: does the' text' type cann't store more than 20,000char ?

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "xu hai" <xvhai(at)21cn(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: does the' text' type cann't store more than 20,000char ?
Date: 2000-05-31 01:49:51
Message-ID: 003501bfcaa2$8d52f4c0$0300000a@doot.org (view raw or flat)
Thread:
Lists: 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(at)21cn(dot)com>
To: <pgsql-sql(at)postgresql(dot)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
>


In response to

pgsql-sql by date

Next:From: Thomas LockhartDate: 2000-05-31 02:04:12
Subject: Re: [HACKERS] Re: aliases break my query
Previous:From: xu haiDate: 2000-05-31 01:11:16
Subject: does the' text' type cann't store more than 20,000char ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group