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
Hi Sergio,
It looks those processes are locked out of the table they want to
write to. In MySQL you can check this kind of stuff with a SHOW
PROCESSLIST; the PostgreSQL equivalent should be SELECT * FROM
pg_stat_activity. Its output might very well shed some light.
Just btw, the number of pmacct
Hi Chris,
I think it would make no semantic difference, but would increase MySQL
performance with these table types, if the primary key listed
stamp_inserted first instead of last.
The change you propose, as you say, would not be impacting - but would
you have any testing handy which