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
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 |