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