How to do indexing, partition, and migration in Postgres 10: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 14: | Line 14: | ||
<pre> | <pre> | ||
Output | Output: | ||
data_directory | data_directory | ||
------------------------- | ------------------------- |
Revision as of 20:21, 3 August 2018
This tutorial shows how to do data migration, partition, and indexing in Postgres 10.
1. Migrate data directory
The dataset is quite large, and it will take up about 220GB of hard disk once loaded and indexed into Postgres. It is better to move the database storage to another large disk instead of the default (root) one. A Solid State Disk (SSD) is preferred for faster disk access.
(1) Check current Postgres data directory.
sudo -i su - postgres psql SHOW data_directory;
Output: data_directory ------------------------- /var/lib/pgsql/10/data (1 row)