[pmacct-discussion] pmacct 0.12.2 released !

2010-05-27 Thread Paolo Lucente
VERSION. 0.12.2 DESCRIPTION. pmacct is a small set of passive network monitoring tools to account, classify, aggregate and export IPv4 and IPv6 traffic; a pluggable architecture allows to store collected network data into memory tables or SQL (MySQL, SQLite, PostgreSQL) databases and export them

Re: [pmacct-discussion] PostgreSQL large database

2010-05-27 Thread Sergio Charpinel Jr.
Hi, Thanks for your supporting. Just to finish this thread, I have made some changes, and the problem stopped. I'll report them here: - I'm using postgresql.conf default from CentOS, and increased checkpoint_segments. - I'm using sql_cache_entries: 263167 - rebuild my index and pk ( still

Re: [pmacct-discussion] PostgreSQL large database

2010-05-27 Thread Karl O. Pinc
On 05/27/2010 07:06:50 AM, Sergio Charpinel Jr. wrote: - I'm running analyze in every insert, within the create table function: CREATE OR REPLACE FUNCTION cria_tab_pmacct(text) RETURNS void AS $$ DECLARE myrec RECORD; BEGIN SELECT 1 INTO myrec FROM pg_catalog.pg_class WHERE