X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E5F9DD1F26C for ; Thu, 6 May 2004 05:09:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53891-02 for ; Thu, 6 May 2004 05:09:22 -0300 (ADT) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id BADF5D1F26D for ; Thu, 6 May 2004 05:09:19 -0300 (ADT) Received: from solent (82-68-95-1.dsl.in-addr.zen.co.uk [82.68.95.1]) by bayswater1.ymogen.net (Postfix) with ESMTP id 113E89C88F; Thu, 6 May 2004 09:08:38 +0100 (BST) From: "Matt Clark" To: Cc: Subject: Postgres & large objects Date: Thu, 6 May 2004 09:09:28 +0100 Message-ID: <006f01c43341$73ed9f60$8300a8c0@solent> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0070_01C43349.D5B45150" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200405/56 X-Sequence-Number: 13372 This is a multi-part message in MIME format. ------=_NextPart_000_0070_01C43349.D5B45150 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello all, 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... Cheers Matt ------=_NextPart_000_0070_01C43349.D5B45150 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
Hello=20 all,
 
It seems = I'm trying=20 to solve the same problem as Richard Emberson had a while ago (thread here:= = http://archives.postgresql.org/pgsql-general/2002-03/msg01199.php).&nbs= p;
 
Essential= ly I am=20 storing a large number of large objects in the DB (potentially tens or hund= reds=20 of gigs), and would like the pg_largeobject table to be stored on a separat= e=20 FS.  But of course it's not just one file to symlink and then forget a= bout,=20 it's a number of files that get created.
 
So, has a= nyone come=20 up with a way to get the files for a table created in a particular place?&n= bsp;=20 I know that tablespsaces aren't done yet, but a kludge will do (or a patch = come=20 to that - we're runing redhat's 7.2.3 RPMs, but could switch if=20 necessary).  I had thought that if the filenames were predictable it m= ight=20 be possible to precreate a bunch of zero-length files and symlink them in= =20 advance...
 
Cheers
 
Matt
 
 
------=_NextPart_000_0070_01C43349.D5B45150--