Managing postgres db size

General talk
1

Hi,

I appear to be running out of disk space on the drive that hosts our postgres db for osm nominatim and overpass…

$ du -s -k postgres
2084338348 postgres

$ df -kl /opt/osm
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/xvdf 2096128000 2096127980 20 100% /opt/osm

Does the size indicate any possible bloat or unneeded table data or logs?
Are there any configuration options to manage disk space required to support nominatim and minutely updates?
Other than host on a larger drive, are there options to stay within the disk limits?

Thanks for any pointers. Searched for related posts, but found nothing that quite matches.

2

I also see a large osmosischange.osc…

/opt/osm/nominatim/Nominatim-3.5.2/build $ ls -rtl
total 905016
drwxrwxr-x 3 ec2-user ec2-user 23 Oct 3 2020 Testing
-rw-r–r-- 1 ec2-user ec2-user 2628 Oct 3 2020 DartConfiguration.tcl
-rw-r–r-- 1 ec2-user ec2-user 1940 Oct 3 2020 mkdocs.yml
-rw-rw-r-- 1 ec2-user ec2-user 25534 Oct 3 2020 CMakeCache.txt
-rw-rw-r-- 1 ec2-user ec2-user 22940 Oct 3 2020 Makefile
-rw-rw-r-- 1 ec2-user ec2-user 1992 Oct 3 2020 CTestTestfile.cmake
-rw-rw-r-- 1 ec2-user ec2-user 1985 Oct 3 2020 cmake_install.cmake
drwxrwxr-x 5 ec2-user ec2-user 220 Oct 3 2020 docs
-rw-rw-r-- 1 ec2-user ec2-user 32180 Oct 3 2020 compile_commands.json
drwxrwxr-x 4 ec2-user ec2-user 111 Oct 3 2020 osm2pgsql
drwxrwxr-x 3 ec2-user ec2-user 133 Oct 3 2020 module
drwxrwxr-x 2 ec2-user ec2-user 43 Oct 3 2020 settings
drwxrwxr-x 2 ec2-user ec2-user 238 Oct 4 2020 website
drwxrwxr-x 33 ec2-user ec2-user 4096 Oct 5 2020 CMakeFiles
-rw-r–r-- 1 root root 142 Oct 5 2020 install_manifest.txt
drwxrwxr-x 2 ec2-user ec2-user 207 Oct 5 2020 utils
-rw-r–r-- 1 ec2-user ec2-user 926622365 Feb 22 16:40 osmosischange.osc

Is this file a list of incremental diffs since the original import? Can this file be trimmed or merged?