Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tchongking@hotmail.com>) id 1TOl4Y-00060q-Tj
	for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 08:03:19 +0000
Received: from sam.nabble.com ([216.139.236.26])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tchongking@hotmail.com>) id 1TOl4R-0006dm-Ai
	for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 08:03:15 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <tchongking@hotmail.com>) id 1TOl4Q-0007Zo-2p
	for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 01:03:10 -0700
Date: Thu, 18 Oct 2012 01:03:10 -0700 (PDT)
From: teyking2003 <tchongking@hotmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1350547390079-5728767.post@n5.nabble.com>
Subject: Database in psql
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.1 (/)
X-Archive-Number: 201210/92
X-Sequence-Number: 40208

i'm a very fresh on psql+linux setup. 
at my side, i have linux ubuntu 2.6.22-14 server + psql 8.2.5+bluedragon web
server. im confuse with vacuum steps, normally i use 
*psql database_name
database_name=# vacuum;/vacuum full/ vacuum full analyst*
to perform basic maintenance to the system. but the user sometimes was feel
very slow while accessing using browser, information search will hang over
there.

Need to ask all the expert here, i have a schedule running on every night to
backup the database to name.sql file, i found this files was grown everyday
until 1.3GB now. is it the slow because of the database? or any idea that i
can reduce the database size.



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Database-in-psql-tp5728767.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.