Yeah we have considered this, and are attempting it. What does the QN
and ET parts of the statement mean when purging?
Ex: QN: 12482/32819, ET: 8978
On 04/28/2016 08:01 AM, Matthew Walster wrote:
On 27 April 2016 at 20:42, Anthony Rodriguez
<anthony.rodrig...@netwolves.com
<mailto:anthony.rodrig...@netwolves.com>>wrote:
Hi,
I have set up a test capturing NF into a postgresql 8.4 DB. It
seems to work OK but the writing to the DB seems
to get far behind. I had one writer take 1.5 hours to sync. Any
hints would be appreciated.
Apr 27 10:30:01 nfacctd[31907]: INFO ( default/pgsql ): ***
Purging cache - START (PID: 31907) ***
Apr 27 12:59:39 nfacctd[31907]: INFO ( default/pgsql ): ***
Purging cache - END (PID: 31907,QN: 12482/32819, ET: 8978) ***
Have you considered moving to INSERTs rather than UPDATEs?
Config key is "
sql_dont_try_update
"
M
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
--
Anthony Rodriguez
Software Engineer I
NetWolves
Email: anthony.rodrig...@netwolves.com
www.netwolves.com
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists