pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedlarge objects
7+ messages / 6 participants
[nested] [flat]
* large objects
@ 1999-03-17 21:54 Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 2 replies; 7+ messages in thread
From: Bruce Momjian @ 1999-03-17 21:54 UTC (permalink / raw)
To: lockhart@alumni.caltech.edu; +Cc: docs@postgresql.org
I noticed that there is no mention of large objects in the users guide,
but it is in the integrated documenation. Is this intended?
Also, you have been quiet for a while. Problem?
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [DOCS] large objects
@ 1999-03-18 07:18 The Hermit Hacker <scrappy@hub.org>
parent: Bruce Momjian <maillist@candle.pha.pa.us>
1 sibling, 1 reply; 7+ messages in thread
From: The Hermit Hacker @ 1999-03-18 07:18 UTC (permalink / raw)
To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; PostgreSQL-documentation <docs@postgreSQL.org>
Ummm...Thomas' computer blew up this past week...I know he sent me email
on it, and said he'd be offline for a little bit...thought you were CC'd
in on that one...*raised eyebrow*
On Wed, 17 Mar 1999, Bruce Momjian wrote:
> I noticed that there is no mention of large objects in the users guide,
> but it is in the integrated documenation. Is this intended?
>
> Also, you have been quiet for a while. Problem?
>
> --
> Bruce Momjian | http://www.op.net/~candle
> maillist@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [DOCS] large objects
@ 1999-03-18 15:59 Bruce Momjian <maillist@candle.pha.pa.us>
parent: The Hermit Hacker <scrappy@hub.org>
0 siblings, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 1999-03-18 15:59 UTC (permalink / raw)
To: scrappy@hub.org; +Cc: lockhart@alumni.caltech.edu; docs@postgreSQL.org
>
> Ummm...Thomas' computer blew up this past week...I know he sent me email
> on it, and said he'd be offline for a little bit...thought you were CC'd
> in on that one...*raised eyebrow*
>
Yes, he was going away, but I thought he would be back by now.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: large objects
@ 1999-03-26 16:28 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Bruce Momjian <maillist@candle.pha.pa.us>
1 sibling, 0 replies; 7+ messages in thread
From: Thomas Lockhart @ 1999-03-26 16:28 UTC (permalink / raw)
To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: PostgreSQL-documentation <docs@postgresql.org>
> I noticed that there is no mention of large objects in the users
> guide, but it is in the integrated documenation. Is this intended?
The large object chapter shows up in the Programmer's Guide, not in
the User's Guide. istm that large objects should be mentioned in the
User's Guide, if they are not already, but that they are something
that a programmer would want to use, not a non-programming user.
Comments?
> Also, you have been quiet for a while. Problem?
I've pretty much recovered from failures of two disks, but upgrading
my system to a fresh version of linux. And, I'm now back in town from
a business trip. So, you should be hearing more from me...
- Tom
^ permalink raw reply [nested|flat] 7+ messages in thread
* Large Objects
@ 2001-09-15 14:33 Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 7+ messages in thread
From: Peter Eisentraut @ 2001-09-15 14:33 UTC (permalink / raw)
To: pgsql-docs
Chapter 2, Programmer's Guide says:
| In Postgres, data values are stored in tuples and individual tuples
| cannot span data pages. Since the size of a data page is 8192 bytes, the
| upper limit on the size of a data value is relatively low. To support the
| storage of larger atomic values, Postgres provides a large object
| interface.
This is relatively untrue. We need to come up with a better reason for
why the large object interface exists, if only because the above *used* to
be true.
Any ideas?
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Large Objects
@ 2001-09-16 05:56 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2001-09-16 05:56 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
Peter Eisentraut <peter_e@gmx.net> writes:
> We need to come up with a better reason for
> why the large object interface exists, if only because the above *used* to
> be true.
Other than backwards compatibility, the only usefulness of the LO
interface (IMHO) is that it provides random access to LO contents ---
ie, the ability to read or write small chunks of a large value.
TOAST can't completely replace LOs until we have a similar capability
for large toasted values.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Large Objects
@ 2002-01-23 10:49 Jean-Paul ARGUDO <jean-paul.argudo@idealx.com>
0 siblings, 0 replies; 7+ messages in thread
From: Jean-Paul ARGUDO @ 2002-01-23 10:49 UTC (permalink / raw)
To: pgsql-docs
Hi all,
I searched to know more about LARGE OBJECTS. Since I come from Oracle
world, I first checked section DATATYPES in the admin guide... I read
about the CREATE DATATYPE, but I couldn't figure out with this with
Large Objects..
I knew that PostgreSQL support long datatypes but I wanted to implement
it in my database (got to store images .jpg ...).
Searching the doc around and around, I finaly found on
developers.postgresql.org the dev projects and TOAST project.
I read line « TOAST implemented in 7.1 » !!!
Since I am in 7.1.3 I search the doc (nasty grep) about TOAST.
I found then all the doc on Large Objects in the Programmer's Guide
section « client interfaces » :-)
Is this a good place for that? Maybe yes, because thinking about what
does the backend to store these oid's...
So my request is « Please add a link from DATATYPE pages to theses pages
about Large Object ».. Just to let know people like me that Large
Objects can be stored in PostgreSQL.
Thanks in advance!
--
Jean-Paul ARGUDO IDEALX S.A.S
Consultant bases de données 15-17, av. de Ségur
http://IDEALX.com/ F-75007 PARIS
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2002-01-23 10:49 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-17 21:54 large objects Bruce Momjian <maillist@candle.pha.pa.us>
1999-03-18 07:18 ` The Hermit Hacker <scrappy@hub.org>
1999-03-18 15:59 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-03-26 16:28 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2001-09-15 14:33 Large Objects Peter Eisentraut <peter_e@gmx.net>
2001-09-16 05:56 ` Re: Large Objects Tom Lane <tgl@sss.pgh.pa.us>
2002-01-23 10:49 Large Objects Jean-Paul ARGUDO <jean-paul.argudo@idealx.com>
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