Database in psql

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.