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" <a...@squeakycode.net> Para: "Michael Kohl" <michael.k...@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<a...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
