Vacuum muy lento

From: "Andrea" <andrea(at)compesa(dot)com(dot)br>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Cc: "Andrea" <andrea(at)compesa(dot)com(dot)br>
Subject: Vacuum muy lento
Date: 2007-04-20 15:35:17
Message-ID: 005601c78361$8002ec10$2815640a@ddm67838
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda


Hola lista..

Tengo PostgreSql 8.1 en LINUX 2.6 y en una maquina RISC con 14 GB RAM.
Una base de datos con 221 GB.

Lo que ocorre es que :
1. o pg_dump desta base lleva 4 horas.
2. el vacuum analyze 10 horas. Lo hago todos los dias.

Gustaría de saber:
1. se hay una manera de disminuir el tempo de vacuum analyze ?
2. como nunca hice un vacuum full tengo medo que lleva una semaña para concluir.
Qué puedo hacer para que yo sepa cuanto tiempo llevara este comando ?

Gracias por la ayuda

Andrea
DBA_Compesa
Recife_Brasil

Sigue abajo algunas configuraciones de mi servidor PostgreSql:

cat /proc/version
Linux version 2.6.9-34.EL (bhcompile(at)js20-bc1-8(dot)build(dot)redhat(dot)com) (gcc version 3.4.5 20051201 (Red Hat 3.4.5-2)) #1 SMP Fri Feb 24 16:46:57 EST 2006

postgresql.conf
listen_addresses = '*'
max_connections = 200
unix_socket_permissions = 0770
shared_buffers = 400000
work_mem = 16384
maintenance_work_mem = 32768
max_fsm_pages = 980000
max_fsm_relations = 4000
vacuum_cost_delay = 10
vacuum_cost_limit = 200
fsync = false
checkpoint_segments = 15
effective_cache_size = 32768
random_page_cost = 2
redirect_stderr = on
log_line_prefix = '%u %t %d '
log_statement = 'mod'
stats_start_collector = on
stats_command_string = on
stats_row_level = on
search_path = '$user,public'

/etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 0

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 1

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
kernel.shmmax = 9999999999
kernel.shmmni = 9999999999


Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alejandro D. Burne 2007-04-20 15:58:13 Re: Mondriam y Postgres
Previous Message Sebastián Villalba 2007-04-20 15:25:03 Re: Mondriam y Postgres