Re: Large Object Location in 7.3

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 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.

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

If Richard's envisioning more than 1GB of large objects, I don't think
he's going to be very satisfied with manual symlinking.

This does bring up an interesting point: the tablespace schemes we've
discussed so far don't allow system catalogs to be moved out of the
default tablespace for a database.  That doesn't bother me for most
of the system catalogs ... but pg_largeobject seems like it might be
an exception.

            regards, tom lane