All Questions
4 questions
1
vote
1
answer
1k
views
PostgreSQL: Table and index on different tablespace
In PostgreSQL i have the freedom of choosing to put index (of a table or materialized view) on tablespace other than the one i chose for the table (or materialized view) itself.
Is there any ...
- 219
0
votes
1
answer
2k
views
How to import an existing schema and tablespace into a postgres database, from a filesystem-level backup
Follow-up question from:
Have postgres' pg_dump export an index
Say I have an existing database, and I want to add to it another schema with content. I saved that content previously through a ...
- 135
4
votes
1
answer
922
views
In PostgreSQL, can you read from an index during a ALTER INDEX ... SET TABLESPACE operation?
I have a PostgreSQL 9.3 server, and there's a large index that I want to move to another tablespace on another disk, because I want to free up space on the original disk. However this is a production ...
- 977
2
votes
1
answer
210
views
How do I recover my database after losing a tablespace with indexes?
I'm thinking of moving all the indexes in my PostgreSQL 9.3 database to a tablespace on an SSD for improved performance. This SSD is not in a RAID array and I need to consider a scenario where it ...
- 471