Hi, After less than one day running pmacct, my database grew from 1.5G to 15G. At this point I get a lot of postmaster and nfacctd process, and none of them seems to be using CPU and not writting in DB.
6774 root 15 0 160m 103m 916 S 0.0 0.9 0:04.04 nfacctd 6775 postgres 15 0 2210m 1.3g 1.3g S 0.0 11.8 0:31.50 postmaster 6784 root 15 0 160m 103m 916 S 0.0 0.9 0:04.19 nfacctd 6785 postgres 16 0 2210m 1.1g 1.1g S 0.0 9.9 0:23.77 postmaster 6794 root 15 0 160m 103m 916 S 0.0 0.9 0:02.81 nfacctd 6795 postgres 15 0 2210m 1.1g 1.1g S 0.0 9.4 0:20.57 postmaster 6804 root 15 0 160m 103m 916 S 0.0 0.9 0:02.04 nfacctd 6805 postgres 16 0 2210m 870m 867m S 0.0 7.4 0:14.03 postmaster 6819 root 15 0 160m 103m 916 S 0.0 0.9 0:02.64 nfacctd 6820 postgres 15 0 2210m 816m 813m S 0.0 7.0 0:13.14 postmaster 6829 root 15 0 160m 103m 916 S 0.0 0.9 0:01.17 nfacctd 6830 postgres 15 0 2210m 625m 622m S 0.0 5.3 0:09.63 postmaster 6861 root 15 0 160m 103m 916 S 0.0 0.9 0:01.28 nfacctd 6862 postgres 15 0 2210m 558m 556m S 0.0 4.8 0:08.16 postmaster 6889 root 15 0 160m 103m 916 S 0.0 0.9 0:00.33 nfacctd 6890 postgres 16 0 2210m 269m 267m D 0.0 2.3 0:03.16 postmaster I don't know who is causing this (nfacctd or postgresql) and which options I should tune. Here is my relevant options: nfacctd: sql_refresh_time: 300 sql_history: 5m sql_history_roundoff: m sql_dont_try_update: true sql_use_copy: true !sql_cache_entries: 1000003 sql_cache_entries: 263167 nfacctd_time_new: true plugin_buffer_size: 102400 plugin_pipe_size: 10240000 Postgresql: shared_buffers = 262144 work_mem = 20971 checkpoint_segments = 50 Thanks for any help! -- Sergio Roberto Charpinel Jr.
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
