Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CF6841337B69 for ; Thu, 27 Jan 2011 16:21:44 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 73665-05 for ; Thu, 27 Jan 2011 20:21:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx3.uci.cu (mx3.uci.cu [200.55.140.180]) by mail.postgresql.org (Postfix) with SMTP id 3DAA71337B5E for ; Thu, 27 Jan 2011 16:21:32 -0400 (AST) Received: (qmail 19538 invoked by uid 507); 27 Jan 2011 20:21:20 -0000 Received: from 10.0.0.185 by ns3.uci.cu (envelope-from , uid 501) with qmail-scanner-2.01st (avp: 5.0.2.0. spamassassin: 3.0.6. perlscan: 2.01st. Clear:RC:1(10.0.0.185):. Processed in 0.796037 secs); 27 Jan 2011 20:21:20 -0000 Received: from unknown (HELO ucimail4.uci.cu) (10.0.0.185) by 0 with SMTP; 27 Jan 2011 20:21:19 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by ucimail4.uci.cu (Postfix) with ESMTP id C334814C403D; Thu, 27 Jan 2011 15:21:19 -0500 (CST) X-Virus-Scanned: amavisd-new at uci.cu Received: from ucimail4.uci.cu ([127.0.0.1]) by localhost (ucimail4.uci.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id hRkFghrOkxLY; Thu, 27 Jan 2011 15:21:17 -0500 (CST) Received: from ucimail4.uci.cu (ucimail4.uci.cu [10.0.0.185]) by ucimail4.uci.cu (Postfix) with ESMTP id 06E7214C4048; Thu, 27 Jan 2011 15:21:17 -0500 (CST) Date: Thu, 27 Jan 2011 15:21:16 -0500 (CST) From: "Ing. Marcos Ortiz Valmaseda" To: Andy Colson Cc: pgsql-performance@postgresql.org, Michael Kohl Message-ID: <1854708499.53552821296159676995.JavaMail.root@ucimail4.uci.cu> In-Reply-To: <921423936.53552111296159628971.JavaMail.root@ucimail4.uci.cu> Subject: Re: High load, MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Originating-IP: [10.0.0.186] X-Mailer: Zimbra 5.0.16_GA_2921.RHEL5_64 (ZimbraWebClient - FF3.0 (Win)/5.0.16_GA_2921.RHEL5_64) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/288 X-Sequence-Number: 42075 Another advice is to look the presentation of Alexander Dymo, on the RailsC= onf2009 called: Advanced Performance Optimization of Rails Applications ava= ilable on=20 http://en.oreilly.com/rails2009/public/schedule/detail/8615 This talk are focused on Rails and PostgreSQL, based on the development of = the Acunote =C2=B4s Project Management Platform http://blog.pluron.com ----- Mensaje original ----- De: "Andy Colson" Para: "Michael Kohl" CC: pgsql-performance@postgresql.org Enviados: Jueves, 27 de Enero 2011 12:20:18 GMT -05:00 Regi=C3=B3n oriental= EE. UU./Canad=C3=A1 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 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=20 you start swapping? -Andy --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance --=20 Ing. Marcos Lu=C3=ADs Ort=C3=ADz Valmaseda System Engineer -- Database Administrator Centro de Tecnolog=C3=ADas de Gesti=C3=B3n de Datos (DATEC) Universidad de las Ciencias Inform=C3=A1ticas http://postgresql.uci.cu