v3_A008_test.md

A008 Disk usage and file system type

Output of df -TPh (follows symlinks)

Observations

Master (db2)

Name	FS Type	Size	Available	Use	Used	Mount Point	Path	Device
PGDATA	ext4	5.4T	4.1T	1.1T	22%	/var/lib/postgresql	/var/lib/postgresql/9.6/main	/dev/mapper/cachedev0
WAL directory	ext4	5.4T	4.1T	1.1T	22%	/var/lib/postgresql	/var/lib/postgresql/9.6/main/pg_xlog	/dev/mapper/cachedev0
stats_temp_directory	tmpfs	32G	32G	3.1M	1%	/dev/shm	/dev/shm	tmpfs
log_directory	ext4	5.4T	4.1T	1.1T	22%	/var/lib/postgresql	/var/lib/postgresql/9.6/main/pg_log	/dev/mapper/cachedev0

Replica servers:

Replica (db3)

Name	FS Type	Size	Available	Use	Used	Mount Point	Path	Device
PGDATA	ext4	5.4T	4.1T	1.1T	22%	/var/lib/postgresql	/var/lib/postgresql/9.6/main	/dev/mapper/cachedev0
WAL directory	ext4	5.4T	4.1T	1.1T	22%	/var/lib/postgresql	/var/lib/postgresql/9.6/main/pg_xlog	/dev/mapper/cachedev0
stats_temp_directory	tmpfs	32G	32G	420K	1%	/dev/shm	/dev/shm	tmpfs
log_directory	ext4	5.4T	4.1T	1.1T	22%	/var/lib/postgresql	/var/lib/postgresql/9.6/main/pg_log	/dev/mapper/cachedev0

Replica (db4)

Name	FS Type	Size	Available	Use	Used	Mount Point	Path	Device
tablespace_1	ext4	1.8T	1.1T	538G	33%	/home	/home/nikolay/postgres-additiona-data	/dev/md3
tablespace_2	ext4	1.8T	1.1T	538G	33%	/home	/home/pgdata_additional	/dev/md3
PGDATA	ext4	1016G	504G	462G	48%	/	/var/lib/postgresql/9.6/main	/dev/md2
WAL directory	ext4	1016G	504G	462G	48%	/	/var/lib/postgresql/9.6/main/pg_xlog	/dev/md2
stats_temp_directory	tmpfs	3.2G	2.9G	323M	11%	/run	/var/run/postgresql/9.6-main.pg_stat_tmp	tmpfs
log_directory	ext4	1016G	504G	462G	48%	/	/var/log/postgresql	/dev/md2

Conclusions

Recommendations