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