Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9F1E21337B80 for ; Thu, 12 May 2011 05:31:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 34342-02 for ; Thu, 12 May 2011 08:30:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from bloxx.com (fpc1-livi1-0-0-cust1.sgyl.static.cable.virginmedia.com [80.192.120.114]) by mail.postgresql.org (Postfix) with ESMTP id C51A2133798E for ; Thu, 12 May 2011 05:30:49 -0300 (ADT) Received: from caesar.alba.local (172.21.13.10) by bloxx with SMTP id 1448016 Thu, 12 May 2011 09:30:48 +0100 Received: from [172.21.120.15] ([172.21.120.15]) by bloxx.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 12 May 2011 09:30:33 +0100 Subject: Re: Postgres refusing to use >1 core From: Michael Graham To: pgsql-performance@postgresql.org In-Reply-To: <4DCB0802.9060505@peak6.com> References: <4DC81A3F020000250003D433@gw.wicourts.gov> <4DC81D56020000250003D438@gw.wicourts.gov> <4DC8B893.3060908@postnewspapers.com.au> <4DC9E7C5.9080309@postnewspapers.com.au> <4DCAB3A1.2090507@peak6.com> <201105111953.060147@ms14.lnh.mail.rcn.net> <4DCB0802.9060505@peak6.com> Content-Type: text/plain; charset="UTF-8" Date: Thu, 12 May 2011 09:30:33 +0100 Message-ID: <1305189033.15277.32.camel@brutus> Mime-Version: 1.0 X-Mailer: Evolution 2.32.2 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 12 May 2011 08:30:33.0518 (UTC) FILETIME=[DC51E4E0:01CC107E] X-EsetResult: clean, is OK X-EsetId: 9269B4200F54FDB5C324 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/174 X-Sequence-Number: 43683 On Wed, 2011-05-11 at 17:04 -0500, Shaun Thomas wrote: > We hold regular Lunch'n'Learns for our developers to teach them the > good/bad of what they're doing, and that helps significantly. Even > hours later, I see them using the techniques I showed them. The one > I'm presenting soon is entitled '10 Ways to Ruin Performance' and > they're all specific examples taken from day-to-day queries and jobs > here, all from different categories of mistake. It's just a part of > being a good DBA. Do you happen to produce slides for these lunch n learns or are they more informal than that? I guess you can work out where I'm going with this ;) -- Michael Graham