Is it possible to keep indexes on different disk location?

From: "W(dot)P(dot)" <laurentp(at)wp(dot)pl>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Is it possible to keep indexes on different disk location?
Date: 2022-08-18 06:39:27
Message-ID: a5899b4c-e254-8a6c-4217-1b02d9430847@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2022-08-18 06:43:15 Re: Setting up streaming replication on large database (20+ TB) for the first time
Previous Message Christophe Pettus 2022-08-18 06:05:19 Re: Unable to Create or Drop Index Concurrently