pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BLOB Feature Limits
2+ messages / 2 participants
[nested] [flat]

* BLOB Feature Limits
@ 2002-04-24 14:04  Bullock, Dempsey <dempsey.bullock@impactinnovations.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Bullock, Dempsey @ 2002-04-24 14:04 UTC (permalink / raw)
  To: pgsql-sql

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?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BLOB Feature Limits
@ 2002-04-24 18:10  Ian Morgan <imorgan@webcon.net>
  parent: Bullock, Dempsey <dempsey.bullock@impactinnovations.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Ian Morgan @ 2002-04-24 18:10 UTC (permalink / raw)
  To: Bullock, Dempsey <dempsey.bullock@impactinnovations.com>; +Cc: pgsql-sql

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  *
-------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-04-24 18:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-24 14:04 BLOB Feature Limits Bullock, Dempsey <dempsey.bullock@impactinnovations.com>
2002-04-24 18:10 ` Ian Morgan <imorgan@webcon.net>

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