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

Re: [NOVICE] Maximum size before having to use BLOBs.

From: <ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca>
To: Ryan Ho <ryanho(at)pacific(dot)net(dot)sg>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Maximum size before having to use BLOBs.
Date: 2000-06-15 12:20:20
Message-ID: Pine.A41.3.95.1000615061836.44468A@freenet.edmonton.ab.ca (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, 15 Jun 2000, Ryan Ho wrote:

> What is the maximum size 'text' or  'varchar' can support before a BLOB has to be
> used. I need to store some small text files and I don't know how big is too big
> for a 'varchar'.

As I understand things, a "tuple" (all the elements in a row) plus a few
bytes for book-keeping have to be less than 8192 bytes.  I haven't pushed
to see if my understanding is correct.

Gord

Matter Realisations     http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
780/481-8019            ghaverla @ freenet.edmonton.ab.ca


In response to

pgsql-novice by date

Next:From: ghaverlaDate: 2000-06-15 12:21:01
Subject: Re: Maximum size before having to use BLOBs.
Previous:From: Karl F. LarsenDate: 2000-06-15 12:05:24
Subject: Re: SHOW , DESCRIBE, oh what's it called...

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