Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 947BACA1FC2 for ; Fri, 10 Feb 2012 15:23:21 -0400 (AST) Received: from 99-153-64-76.uvs.austtx.sbcglobal.net ([99.153.64.76] helo=noel.decibel.org) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rvw40-0001iZ-Va for pgsql-hackers@postgresql.org; Fri, 10 Feb 2012 19:23:21 +0000 Received: from workbook.local (unknown [38.98.177.253]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTPSA id 42FB56D45D; Fri, 10 Feb 2012 19:23:06 +0000 (UTC) Message-ID: <4F356E98.1050000@nasby.net> Date: Fri, 10 Feb 2012 13:23:04 -0600 From: Jim Nasby Reply-To: jim@nasby.net User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:10.0) Gecko/20120129 Thunderbird/10.0 MIME-Version: 1.0 To: Christian Nicolaisen CC: pgsql-hackers@postgresql.org Subject: Re: patch : Allow toast tables to be moved to a different tablespace References: <4F3267EE.80405@deltasoft.no> In-Reply-To: <4F3267EE.80405@deltasoft.no> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.9 (/) X-Archive-Number: 201202/450 X-Sequence-Number: 202815 On 2/8/12 6:17 AM, Christian Nicolaisen wrote: > Hi > > We have some tables with documents and their metadata (filename, filetype, etc). > Most of the time we just want to get the metadata (filename, filetype, etc) and not the document itself. > In this case it would be nice to have the metadata (which wouldn't end up on the TOAST) on a fast array (SSD-based), > and put the filedata on a slow array (HDD-based). It's probably possible to have two tables one for metadata and one > for the extra file, but this is a workaround. Did you intend to post a patch? Because nothing was attached. Also, if you're submitting a patch you should add it to the next commitfest.