logoalt Hacker News

ComputerGurutoday at 12:22 AM1 replyview on HN

Another option would be a good way of placing indexes on a different physical disk. You could use fast, ephemeral storage like you can for a WAL without amplifying the writes to the same device that is your expensive bottleneck. You could rebuild on data loss.

But it would add complexity to detect out-of-sync indexes and tables.


Replies

SigmundAtoday at 12:41 AM

You mean tablespaces: https://www.postgresql.org/docs/current/manage-ag-tablespace... ?

show 1 reply