Thread: Size of Large objects

Size of Large objects

From
"Bianca Oberst"
Date:
Hello,

I'm new in postgres. I searched the archives, but I don't find an answer. So
can anybody tell me the explicit size, which a clob or a blob can have in
postgres 8.0?

Thank you,
Bianca

--
5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail
+++ GMX - die erste Adresse f���r Mail, Message, More +++


Re: Size of Large objects

From
Peter Eisentraut
Date:
Am Dienstag, 26. Juli 2005 08:37 schrieb Bianca Oberst:
> I'm new in postgres. I searched the archives, but I don't find an answer.
> So can anybody tell me the explicit size, which a clob or a blob can have
> in postgres 8.0?

Columns can contain up to 1 GB of data.  The terms clob or blob are not used
in PostgreSQL; the limitation is the same on all column types.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Size of Large objects

From
"Jim C. Nasby"
Date:
On Tue, Jul 26, 2005 at 09:47:33AM +0200, Peter Eisentraut wrote:
> Am Dienstag, 26. Juli 2005 08:37 schrieb Bianca Oberst:
> > I'm new in postgres. I searched the archives, but I don't find an answer.
> > So can anybody tell me the explicit size, which a clob or a blob can have
> > in postgres 8.0?
>
> Columns can contain up to 1 GB of data.  The terms clob or blob are not used
> in PostgreSQL; the limitation is the same on all column types.

Not entirely true...

decibel=# select version();
 PostgreSQL 8.0.3 on powerpc-apple-darwin7.9.0, compiled by GCC gcc
 (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495)

 decibel=# create table t(v varchar(1000000000));
 ERROR:  length for type varchar cannot exceed 10485760
 decibel=#
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

Re: Size of Large objects

From
"Bianca Oberst"
Date:
Okay, thanks!

Bianca

> --- Ursprüngliche Nachricht ---
> Von: Peter Eisentraut <peter_e@gmx.net>
> An: "Bianca Oberst" <bianca.oberst@gmx.de>
> Kopie: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] Size of Large objects
> Datum: Tue, 26 Jul 2005 09:47:33 +0200
>
> Am Dienstag, 26. Juli 2005 08:37 schrieb Bianca Oberst:
> > I'm new in postgres. I searched the archives, but I don't find an
> answer.
> > So can anybody tell me the explicit size, which a clob or a blob can
> have
> > in postgres 8.0?
>
> Columns can contain up to 1 GB of data.  The terms clob or blob are not
> used
> in PostgreSQL; the limitation is the same on all column types.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
GMX DSL = Maximale Leistung zum minimalen Preis!
2000 MB nur 2,99, Flatrate ab 4,99 Euro/Monat: http://www.gmx.net/de/go/dsl


Re: Size of Large objects

From
Peter Eisentraut
Date:
Am Dienstag, 26. Juli 2005 09:55 schrieb Jim C. Nasby:
>  decibel=# create table t(v varchar(1000000000));
>  ERROR:  length for type varchar cannot exceed 10485760

The length you can declare and the size you can store (if a length declaration
doesn't stop you) are, for various uninteresting reasons, not related.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Size of Large objects

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Dienstag, 26. Juli 2005 09:55 schrieb Jim C. Nasby:
>> decibel=# create table t(v varchar(1000000000));
>> ERROR:  length for type varchar cannot exceed 10485760

> The length you can declare and the size you can store (if a length declaration
> doesn't stop you) are, for various uninteresting reasons, not related.

Also, you can just say "varchar" with no specific length limit, which is
then more or less equivalent to "text".

            regards, tom lane