kr, vc tem que rodar o vaccum.
no script abaixo ele faz o vaccum e o backup dos dados do postgresql Depois diga se ficou mais rapido ou nao! #! /bin/sh # Criar o Usuario dba (useradd dba e o usuario no banco createuser dba) # chown dba /var/lib/pgsql/backups e chmod 777 para esta pasta BACKUP_DIR=/var/lib/pgsql/backups BACKUP_NUM=7 # Vaccum each database and make a backup of the databases databases=`su -l dba -c 'psql -q -t -c "select datname from pg_database;" template1'` for d in $databases; do echo -n "Vacuuming $d... " if su -l dba -c "psql -q -c 'VACUUM' $d"; then echo "done." else echo "" echo "oops" fi if [ ! -d $BACKUP_DIR/$d ]; then echo -n "Creating backup directory $BACKUP_DIR/$d... " su -l dba -c "mkdir $BACKUP_DIR/$d" ] || continue echo "done." fi # Keep a maximum of $BACKUP_NUM number of backups archive=$BACKUP_DIR/$d/$d.gz if [ -f $archive.$BACKUP_NUM ]; then rm -f $archive.$BACKUP_NUM; fi n=$(( $BACKUP_NUM - 1 )) while [ $n -gt 0 ]; do if [ -f $archive.$n ]; then mv $archive.$n $archive.$(( $n + 1 )) fi n=$(( $n - 1 )) done if [ -f $archive ]; then mv $archive $archive.1; fi echo -n "Dumping database $d... " su -l dba -c "(pg_dump -D $d |gzip -9) > $archive" echo "done." done ~ ----- Original Message ----- From: "Adaum" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 8:41 AM Subject: (linux-br) Performance do PostgreSQL Alguem sabe como posso medir a performance do meu banco de dados PostgreSQL, pois o mesmo estah MUUUUITO lento. Obrigado, Adaum --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2002 Assinantes em 25/10/2002: 2224 Mensagens recebidas desde 07/01/1999: 188053 Historico e [des]cadastramento: http://linux-br.conectiva.com.br Assuntos administrativos e problemas com a lista: mailto:linux-br-owner@;bazar.conectiva.com.br
