From: Christian Nicolaisen <christian@deltasoft.no>
To: pgsql-hackers@postgresql.org
Subject: Re: patch : Allow toast tables to be moved to a different tablespace
Date: Wed, 08 Feb 2012 13:17:50 +0100
Message-ID: <4F3267EE.80405@deltasoft.no> (raw)
In-Reply-To: <CA+Tgmob3tKEJ_9U9-SvfUsO_izhC6c47J23Uwf1mD+=4szNiEA@mail.gmail.com>
References: <CA+Tgmob3tKEJ_9U9-SvfUsO_izhC6c47J23Uwf1mD+=4szNiEA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: christian@deltasoft.no
Subject: Re: patch : Allow toast tables to be moved to a different tablespace
In-Reply-To: <4F3267EE.80405@deltasoft.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox