pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ian Morgan <imorgan@webcon.net>
To: Bullock, Dempsey <dempsey.bullock@impactinnovations.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: BLOB Feature Limits
Date: Wed, 24 Apr 2002 14:10:18 -0400 (EDT)
Message-ID: <Pine.LNX.4.44.0204241402080.26231-100000@light.webcon.net> (raw)
In-Reply-To: <9320C6656A6DD411BE4600508B6DCD6802817EDE@IMP-BWC-EXCH>

On Wed, 24 Apr 2002, Bullock, Dempsey wrote:

> I'm new to PGSQL 7.2...
>
> I plan to create an application that stores any kind of document directly
> within the database.  Some of the files could be very large (1MB or larger).
> Where are the limitations documented?

/usr/doc/postgresql-7.2.1/html/largeobjects.html

Section 2.2 says: The large object implementation breaks large objects up
into "chunks" and stores the chunks in tuples in the database. A B-tree
index guarantees fast searches for the correct chunk number when doing
random access reads and writes.

I would presume this to meant that a large object has no finite size
limitation apart from the database itself exceeding disk space limits.

(But I could be wrong, I'm not a PostgreSQL developer.)

BTW: This should probably have been asked on the pgsql-novice list.

Regards,
Ian Morgan
-- 
-------------------------------------------------------------------
 Ian E. Morgan        Vice President & C.O.O.         Webcon, Inc.
 imorgan@webcon.net         PGP: #2DA40D07          www.webcon.net
    *  Customized Linux network solutions for your business  *
-------------------------------------------------------------------




view thread (2+ messages)

Message-ID: <Pine.LNX.4.44.0204241402080.26231-100000@light.webcon.net>
Permalink:  ../Pine.LNX.4.44.0204241402080.26231-100000@light.webcon.net/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0204241402080.26231-100000@light.webcon.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: imorgan@webcon.net, dempsey.bullock@impactinnovations.com
  Subject: Re: BLOB Feature Limits
  In-Reply-To: <Pine.LNX.4.44.0204241402080.26231-100000@light.webcon.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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