Skip site navigation (1) Skip section navigation (2)

Reposted - large object storage

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Reposted - large object storage
Date: 2004-05-10 13:27:21
Message-ID: 02db01c43692$85d35040$8300a8c0@solent (view raw or flat)
Thread:
Lists: pgsql-admin
Hi again,

It seems I posted in HTML before, sorry about that...
 
It seems I'm trying to solve the same problem as Richard Emberson had a
while ago (thread here:
http://archives.postgresql.org/pgsql-general/2002-03/msg01199.php). 
 
Essentially I am storing a large number of large objects in the DB
(potentially tens or hundreds of gigs), and would like the pg_largeobject
table to be stored on a separate FS.  But of course it's not just one file
to symlink and then forget about, it's a number of files that get created.
 
So, has anyone come up with a way to get the files for a table created in a
particular place?  I know that tablespsaces aren't done yet, but a kludge
will do (or a patch come to that - we're runing redhat's 7.2.3 RPMs, but
could switch if necessary).  I had thought that if the filenames were
predictable it might be possible to precreate a bunch of zero-length files
and symlink them in advance, but that's perhaps _too_ kludgey...

I'm having a rummage around in the code at the moment, and it seems like it
might be possible to get PG to put each table in its own directory.  Anybody
seen that tried before?
 
Cheers
 
Matt
 
 



pgsql-admin by date

Next:From: Arno KarnerDate: 2004-05-11 08:25:57
Subject: a warnig yes, but to worry or not
Previous:From: Armel HERVEDate: 2004-05-10 12:22:14
Subject: Re: User defined type in C

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group