From: Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
To: Andy Colson <andy@squeakycode.net>
Cc: pgsql-performance@postgresql.org, Michael Kohl <michael.kohl@tupalo.com>
Subject: Re: High load,
Date: Thu, 27 Jan 2011 15:21:16 -0500 (CST)
Message-ID: <1854708499.53552821296159676995.JavaMail.root@ucimail4.uci.cu> (raw)
In-Reply-To: <921423936.53552111296159628971.JavaMail.root@ucimail4.uci.cu>
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
http://blog.pluron.com
----- Mensaje original -----
De: "Andy Colson" <andy@squeakycode.net>
Para: "Michael Kohl" <michael.kohl@tupalo.com>
CC: pgsql-performance@postgresql.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@squeakycode.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@postgresql.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlortiz@uci.cu, andy@squeakycode.net, michael.kohl@tupalo.com
Subject: Re: High load,
In-Reply-To: <1854708499.53552821296159676995.JavaMail.root@ucimail4.uci.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox