postgres

took from https://wiki.postgresql.org/wiki/Show_database_bloat

example: psql -U username -qAt -c «select ftp_file_path from ftp_file_headers where 1=1 and ftp_file_type=’tm’;» | while read folder; do echo $folder ; done

Test was done on VM with 4X CPU E5-2660 2.20GHz + 4GB mem with tools written by pgbench-tools on postgresql 9.4.5 settings: run test 3 times by 10 min, db size 100(1.5gb) 400(6gb) 700 (10gb) 1000 (15gb), clients 1,2,4,8,16,32 Results: with the exception of an anomalous drawdown in the last test, without selinux performance gain … Читать далее

usefull materials github postgrespro Waits monitoring on mail list of postgresql.org pgconf2015 slides Packages ubuntu: fedora: Install from source enable waits monitoring add to postgresql.conf ### alter system set waits_monitoring=on; ps: Many thanks to Vladimir Borodin for help !