Re: Large Object Location in 7.3

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.

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