From: | "Ing(dot) Marcos Ortiz Valmaseda" <mlortiz(at)uci(dot)cu> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | pgsql-performance(at)postgresql(dot)org, Michael Kohl <michael(dot)kohl(at)tupalo(dot)com> |
Subject: | Re: High load, |
Date: | 2011-01-27 20:21:16 |
Message-ID: | 1854708499.53552821296159676995.JavaMail.root@ucimail4.uci.cu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Another advice is to look the presentation of Alexander Dymo, on the RailsConf2009 called: Advanced Performance Optimization of Rails Applications available on
http://en.oreilly.com/rails2009/public/schedule/detail/8615
This talk are focused on Rails and PostgreSQL, based on the development of the Acunote ´s Project Management Platform
----- Mensaje original -----
De: "Andy Colson" <andy(at)squeakycode(dot)net>
Para: "Michael Kohl" <michael(dot)kohl(at)tupalo(dot)com>
CC: pgsql-performance(at)postgresql(dot)org
Enviados: Jueves, 27 de Enero 2011 12:20:18 GMT -05:00 Región oriental EE. UU./Canadá
Asunto: Re: [PERFORM] High load,
On 1/27/2011 9:09 AM, Michael Kohl wrote:
> On Thu, Jan 27, 2011 at 4:06 PM, Andy Colson<andy(at)squeakycode(dot)net> wrote:
>> Have you run each of your queries through explain analyze lately?
>
> A code review including checking of queries is on our agenda.
>
>> You are vacuuming/autovacuuming, correct?
>
> Sure :-)
>
> Thank you,
> Michael
>
Oh, also, when the box is really busy, have you watched vmstat to see if
you start swapping?
-Andy
--
Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
--
Ing. Marcos Luís Ortíz Valmaseda
System Engineer -- Database Administrator
Centro de Tecnologías de Gestión de Datos (DATEC)
Universidad de las Ciencias Informáticas
http://postgresql.uci.cu
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2011-01-27 20:31:40 | Re: Postgres 9.0 has a bias against indexes |
Previous Message | Igor Neyman | 2011-01-27 20:10:56 | Re: Postgres 9.0 has a bias against indexes |