pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedMore about large objects
5+ messages / 2 participants
[nested] [flat]
* More about large objects
@ 1999-02-02 04:43 Gregory W Burnham <gburnham@sfu.ca>
1999-02-02 05:31 ` Re: [INTERFACES] More about large objects Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Gregory W Burnham @ 1999-02-02 04:43 UTC (permalink / raw)
To: pgsql-interfaces
According to the postgresql docs, (at
http://looking-glass.usask.ca/postgresql/docs/postgres/largeobjects.htm)
Originally, Postgres 4.2 supported three standard implementations of large
objects: as files external to Postgres, as UNIX files managed by Postgres,
and as data stored within the Postgres database. It causes considerable
confusion among users. As a result, we only support large objects as data
stored within the Postgres database in PostgreSQL.
---------------
Now I'm confused. From what I'd gather from earlier today, Postgres used
external files. Are the docs that out of date?
Gregory W Burnham
Software Engineer
Excite Labs
Faculty Of Education
Simon Fraser University
Vancouver, BC, V5A 1S6
604 291 3615 (ph)
604 291 5679 (fx)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] More about large objects
1999-02-02 04:43 More about large objects Gregory W Burnham <gburnham@sfu.ca>
@ 1999-02-02 05:31 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Thomas G. Lockhart @ 1999-02-02 05:31 UTC (permalink / raw)
To: Gregory W Burnham <gburnham@sfu.ca>; +Cc: pgsql-interfaces
> Now I'm confused. From what I'd gather from earlier today, Postgres
> used external files. Are the docs that out of date?
Which docs? What were you gathering, and where??
- Tom
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] More about large objects
@ 1999-02-02 05:29 Gregory W Burnham <gburnham@sfu.ca>
1999-02-02 15:35 ` Re: [INTERFACES] More about large objects Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Gregory W Burnham @ 1999-02-02 05:29 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; pgsql-interfaces
The postgresql docs, I posted the url didn't I? Here it is again.
http://looking-glass.usask.ca/postgresql/docs/postgres/largeobjects.htm
And this is a quote from that page.
<QUOTE>
Originally, Postgres 4.2 supported three standard implementations of large
objects: as files external to Postgres, as UNIX files managed by Postgres,
and as data stored within the Postgres database. It causes considerable
confusion among users. As a result, we only support large objects as data
stored within the Postgres database in PostgreSQL.
</QUOTE>
So according to this, the large objects are stored in the table But
from what I gather from the earlier large object talk, and from my
own observation, postgres uses external files. Am I deluded? Am I
missing something?
Gregory W Burnham
Software Engineer
Excite Labs
Faculty Of Education
Simon Fraser University
Vancouver, BC, V5A 1S6
604 291 3615 (ph)
604 291 5679 (fx)
----- Original Message -----
From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Gregory W Burnham <gburnham@sfu.ca>
Cc: <pgsql-interfaces@postgreSQL.org>
Sent: Monday, February 01, 1999 9:31 PM
Subject: Re: [INTERFACES] More about large objects
>> Now I'm confused. From what I'd gather from earlier today, Postgres
>> used external files. Are the docs that out of date?
>
>Which docs? What were you gathering, and where??
>
> - Tom
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] More about large objects
1999-02-02 05:29 Re: [INTERFACES] More about large objects Gregory W Burnham <gburnham@sfu.ca>
@ 1999-02-02 15:35 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Thomas G. Lockhart @ 1999-02-02 15:35 UTC (permalink / raw)
To: Gregory W Burnham <gburnham@sfu.ca>; +Cc: pgsql-interfaces
> The postgresql docs, I posted the url didn't I?
Uh, yes. I'm familiar with that document, and it is accurate, at least
on that topic.
> So according to this, the large objects are stored in the table But
> from what I gather from the earlier large object talk, and from my
> own observation, postgres uses external files. Am I deluded? Am I
> missing something?
Yes and yes again :)
The current large object implementation stores and accesses files within
the Postgres server. All access to the files happen through the standard
client-server connection.
Internally, Postgres stores all information in files, one file per
table, index, or large object. The large object files can be identified
with a file prefix of "xinv_" (I think; didn't check so it may be
something else) within the internal data storage directory
$(PGDATA)/base/dbname/
Hope this helps...
- Tom
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] More about large objects
@ 1999-02-02 16:08 Gregory W Burnham <gburnham@sfu.ca>
0 siblings, 0 replies; 5+ messages in thread
From: Gregory W Burnham @ 1999-02-02 16:08 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; +Cc: pgsql-interfaces
Ok, I get it. I'd been thinking that the phrase
"we only support large objects as data stored within
the Postgres database" meant that the lo wasn't in
an external file (which, to me, the xinv*s are). But
I think I understand now. Thanks Tom.
----- Original Message -----
From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Gregory W Burnham <gburnham@sfu.ca>
Cc: <pgsql-interfaces@postgreSQL.org>
Sent: Tuesday, February 02, 1999 7:35 AM
Subject: Re: [INTERFACES] More about large objects
>> The postgresql docs, I posted the url didn't I?
>
>Uh, yes. I'm familiar with that document, and it is accurate, at least
>on that topic.
>
>> So according to this, the large objects are stored in the table But
>> from what I gather from the earlier large object talk, and from my
>> own observation, postgres uses external files. Am I deluded? Am I
>> missing something?
>
>Yes and yes again :)
>
>The current large object implementation stores and accesses files within
>the Postgres server. All access to the files happen through the standard
>client-server connection.
>
>Internally, Postgres stores all information in files, one file per
>table, index, or large object. The large object files can be identified
>with a file prefix of "xinv_" (I think; didn't check so it may be
>something else) within the internal data storage directory
>$(PGDATA)/base/dbname/
>
>Hope this helps...
>
> - Tom
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-02-02 16:08 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-02 04:43 More about large objects Gregory W Burnham <gburnham@sfu.ca>
1999-02-02 05:31 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1999-02-02 05:29 Re: [INTERFACES] More about large objects Gregory W Burnham <gburnham@sfu.ca>
1999-02-02 15:35 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1999-02-02 16:08 Re: [INTERFACES] More about large objects Gregory W Burnham <gburnham@sfu.ca>
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