Is it possible to keep indexes on different disk location?

Поиск
Список
Период
Сортировка
От W.P.
Тема Is it possible to keep indexes on different disk location?
Дата
Msg-id a5899b4c-e254-8a6c-4217-1b02d9430847@wp.pl
обсуждение исходный текст
Ответы Re: Is it possible to keep indexes on different disk location?  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: Is it possible to keep indexes on different disk location?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Дерево обсуждения 
Hi there,

I have a PostgreSQL 11 server on OrangePi3 (ARM 64 bit, Armbian, PG from 
distro).

Database (all cluster) is located on USB disk. This approach give me 
already 2 times loosing DB contents (it is a replica of DB on i7).

But the whole thing (mainly indexes) is about 50G, and internal storage 
is only 32GB.

Is it possible to move  DB tables etc to this internal storage (sure 
connection) and put only    indexes on USB  HDD?

And will it help in case of losing connection to USB disk? (DB 
recoverable instead of total crash)?


Laurent

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

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Unable to Create or Drop Index Concurrently
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Setting up streaming replication on large database (20+ TB) for the first time