Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id A24921A3E38A for ; Wed, 8 Feb 2012 08:18:08 -0400 (AST) Received: from mail.deltasoft.no ([93.187.80.16]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rv6TO-0000D3-Im for pgsql-hackers@postgresql.org; Wed, 08 Feb 2012 12:18:07 +0000 Received: from post.deltasoft.no (unknown [10.69.114.19]) by mail.deltasoft.no (Postfix) with ESMTP id 7986EA9010F for ; Wed, 8 Feb 2012 13:17:50 +0100 (CET) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII; format=flowed Received: from [10.69.114.87] ([unknown] [10.69.114.87]) by post.deltasoft.no (Sun Java(tm) System Messaging Server 7u3-12.01 64bit (built Oct 15 2009)) with ESMTPA id <0LZ20014ZQ5QPQ00@post.deltasoft.no> for pgsql-hackers@postgresql.org; Wed, 08 Feb 2012 13:17:50 +0100 (CET) Message-id: <4F3267EE.80405@deltasoft.no> Date: Wed, 08 Feb 2012 13:17:50 +0100 From: Christian Nicolaisen User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:10.0) Gecko/20120129 Thunderbird/10.0 To: pgsql-hackers@postgresql.org Subject: Re: patch : Allow toast tables to be moved to a different tablespace References: In-reply-to: X-deltasoft_no-MailScanner-ID: 7986EA9010F.A4234 X-deltasoft_no-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-deltasoft_no-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (notcached, score=-0.108, required 6, autolearn=not spam, ALL_TRUSTED -1.80, BAYES_50 0.00, RATWARE_GECKO_BUILD 1.69) X-deltasoft_no-MailScanner-From: christian@deltasoft.no X-Spam-Status: No X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/373 X-Sequence-Number: 202738 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. -- Mvh Christian Nicolaisen Deltasoft AS Tlf +47 938 38 596