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@xxxxxxxxxxxxxxx> Para: "Michael Kohl" <michael.kohl@xxxxxxxxxx> CC: pgsql-performance@xxxxxxxxxxxxxx Enviados: Jueves, 27 de Enero 2011 12:20:18 GMT -05:00 RegiÃn oriental EE. UU./Canadà Asunto: Re: High load, On 1/27/2011 9:09 AM, Michael Kohl wrote: > On Thu, Jan 27, 2011 at 4:06 PM, Andy Colson<andy@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
