Re: Large Object Location in 7.3

Richard Emberson wrote:
> Bruce Momjian wrote:
>
> > Richard Emberson wrote:
> > >
> > > I expect (actually hope) to have thousands and thousands of blob/clobs
> > > in the db I am designing.
> > > I would like such largeobjects to be stored in their own file system.
> > > Someone had said that there
> > > might be support for "tablespaces/locations" in 7.3. Is there a
> > > description somewhere of this work
> > > or a "spec"?
> >
> > Sure, find the oid of pg_largeobject and symlink that to another file
> > system. You need to do that toast table and any indexes for the table
> > too.
> >
>
> Can this be done within a PL/pgsql function or does one have to stop the
> database (everytime a
> user enters a new blob) and do it by hand or external script?

pg_largeobject contains all large objects, at least in 7.1 and earlier.
Don't remember about 7.0. Just has to be done once per database, with
system down.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026