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