pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedwhat is maximum size of "text" datatype in postgres?
2+ messages / 2 participants
[nested] [flat]
* what is maximum size of "text" datatype in postgres?
@ 2004-09-13 08:35 Smit <smitamarda@yahoo.co.uk>
2004-09-13 09:31 ` Re: what is maximum size of "text" datatype in postgres? Christopher Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 2+ messages in thread
From: Smit @ 2004-09-13 08:35 UTC (permalink / raw)
To: pgsql-sql
Hi,
i wanted to know, what is maximum size of "text"
datatype in postgres.
It is given as "unlimited characters" in the postgres
documentation.
But it doesn't store characters more than 5000. The
connection get lost if i tried to store more than 5000
characters.
I had read somewhere on forum that its max limit is 8
bytes, and we can increase it to 32 bytes.
Do any one know how to increse it?
or do anyone know any other way to solve this problem.
Thanks,
Smita
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: what is maximum size of "text" datatype in postgres?
2004-09-13 08:35 what is maximum size of "text" datatype in postgres? Smit <smitamarda@yahoo.co.uk>
@ 2004-09-13 09:31 ` Christopher Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 2+ messages in thread
From: Christopher Browne @ 2004-09-13 09:31 UTC (permalink / raw)
To: pgsql-sql
Centuries ago, Nostradamus foresaw when smitamarda@yahoo.co.uk ("Smit") would write:
> i wanted to know, what is maximum size of "text"
> datatype in postgres.
> It is given as "unlimited characters" in the postgres
> documentation.
> But it doesn't store characters more than 5000. The
> connection get lost if i tried to store more than 5000
> characters.
>
> I had read somewhere on forum that its max limit is 8
> bytes, and we can increase it to 32 bytes.
8 bytes is certainly not the right answer.
Creating a little table, and throwing some wide strings at it...
tutorial=# create table widetext (main text);
CREATE
tutorial=# insert into widetext values ('0123456789... repeated a
bunch of times...');
INSERT 2625519 1
... increasing size each time, for several instances ...
tutorial=# select length(main) from widetext;
length
--------
1100
5500
11000
(3 rows)
That's way more than 8 bytes; that's way more than 5000 bytes.
> Do any one know how to increse it? or do anyone know any other way
> to solve this problem.
What tool are you using to insert the data?
Is it possible that it has some buffer size limitation that is biting
you?
--
"cbbrowne","@","ntlug.org"
http://linuxfinances.info/info/
"My experience as a member of the APB (Accounting Principles Board)
taught me many lessons. A major one was that most of us have a
natural tendency and an incredible talent for processing new facts in
such a way that our prior conclusions remain intact."
-- Charles Horngren
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-09-13 09:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-13 08:35 what is maximum size of "text" datatype in postgres? Smit <smitamarda@yahoo.co.uk>
2004-09-13 09:31 ` Christopher Browne <cbbrowne@acm.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox