Re: patch : Allow toast tables to be moved to a different tablespace
Christian Nicolaisen <christian@deltasoft.no>
From: Christian Nicolaisen <christian@deltasoft.no>
To: pgsql-hackers@postgresql.org
Date: 2012-02-08T12:17:50Z
Lists: pgsql-hackers
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