2010/10/5 Martin Li Causi <emlica...@gmail.com>: > Hola! tengo intalado PG8.4.4 en un server que tinen 3G de ram y un xeon con > 4 core de 3Ghz > [...] > > le paso el postgresql.conf para ver si me pueden decirme que les parece...si > cambiarian algo como para tener una referencia donde poder buscar > si les falta algun dato mas diganeme y se los paso
""" temp_buffers = 64MB work_mem = 128MB """ temp_buffers is probably to high, work_mem is definitively high... what you're saying with work_mem=128MB and max_connections=50 is that at some point it could be 128x50 MB of memory used (that is more memory than you have) probably checkpoint_timeout, random_page_cost and effective_cache_size needs a revision too PS: about log the slow sentences... put log_statements in 'none' and log_min_duration_statement in something meaningful i always start with 3s and try to clean most i can before lower that value -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL - Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda@postgresql.org) Para cambiar tu suscripci�n: http://www.postgresql.org/mailpref/pgsql-es-ayuda
