| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Martin Li Causi <emlicausi(at)gmail(dot)com> |
| Cc: | pgsql-es-ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: tunning |
| Date: | 2010-10-06 03:14:49 |
| Message-ID: | AANLkTikb5dNecxwDctC28e5gtJMSjLy1hDOb0j0kZSBO@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
2010/10/5 Martin Li Causi <emlicausi(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Esneiker | 2010-10-06 13:20:55 | importación de datos |
| Previous Message | Alvaro Herrera | 2010-10-05 21:28:59 | Actualizaciones de Seguridad del 5 de octubre de 2010 |