Re: patch : Allow toast tables to be moved to a different tablespace

Поиск
Список
Период
Сортировка
От Christian Nicolaisen
Тема Re: patch : Allow toast tables to be moved to a different tablespace
Дата
Msg-id 4F3267EE.80405@deltasoft.no
обсуждение исходный текст
Ответ на Re: patch : Allow toast tables to be moved to a different tablespace  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: patch : Allow toast tables to be moved to a different tablespace  (Jim Nasby <jim@nasby.net>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: [PATCH] Enable min/max optimization for bool_and/bool_or/every
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Core Extensions relocation