On 04/27/2010 09:36:50 AM, Sergio Charpinel Jr. wrote: > Hi, > > I'm using pmacct 0.12.1 with PostgreSQL 8.4 and FloX. i'm running > pmacctd > and nfacctd daemons (probe and collector). > > After 1 day running, I'm getting 1+min to make a query. > Is there any config in pmacct and PostgreSQL that I can do improve > this?
You may find that allocating more shared memory to postgresql will dramatically improve performance. Depending on how much you allocate this may require a sysctl setting so the kernel will allow more shared memory to be allocated. Karl <k...@meme.com> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists