Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 541259FBC5A
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  5 Apr 2007 11:32:17 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 21107-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  5 Apr 2007 11:32:13 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from correio2.docasdoporto.com.br
	(22.144.199.200.docasdoporto.com.br [200.199.144.22])
	by postgresql.org (Postfix) with ESMTP id F050D9FB54B
	for <pgsql-sql@postgresql.org>; Thu,  5 Apr 2007 11:32:12 -0300 (ADT)
Received: from [201.32.176.97] (account ezequias@fastcon.com.br)
	by correio2.docasdoporto.com.br (CommuniGate Pro WebUser 4.1.8)
	with HTTP id 48201767 for pgsql-sql@postgresql.org;
	Thu, 05 Apr 2007 11:50:00 -0300
From: <ezequias@fastcon.com.br>
Subject: LOG:  unexpected EOF on client connection
To: pgsql-sql@postgresql.org
X-Mailer: CommuniGate Pro WebUser Interface v.4.1.8
Date: Thu, 05 Apr 2007 11:50:00 -0300
Message-ID: <web-48201767@correio2.docasdoporto.com.br>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"; format="flowed"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.116 tagged_above=0 required=5 tests=AWL=-0.105,
	BAYES_20=-0.74, NO_REAL_NAME=0.961
X-Spam-Level: 
X-Archive-Number: 200704/74
X-Sequence-Number: 28074

Hi list,

I am doing a benchmark in my database but it is spent too much time.

I was looking for my log file but I could not understad clearly what it says.

The log is like this:

INT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (4 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (5 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (5 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (8 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index 
"branches_pkey" for table "branches"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index 
"tellers_pkey" for table "tellers"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index 
"accounts_pkey" for table "accounts"
ERROR:  conversion between latin9 and LATIN1 is not supported
STATEMENT:  set client_encoding to 'latin9'
FATAL:  sorry, too many clients already
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection
LOG:  unexpected EOF on client connection

Does anyone have any suggestion ?


--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com