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
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
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