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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
