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