From owner-freebsd-questions@FreeBSD.ORG Wed Jul 25 19:06:12 2007 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 896A516A417 for ; Wed, 25 Jul 2007 19:06:12 +0000 (UTC) (envelope-from maxsec@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by mx1.freebsd.org (Postfix) with ESMTP id 08F3613C46B for ; Wed, 25 Jul 2007 19:06:11 +0000 (UTC) (envelope-from maxsec@gmail.com) Received: by ug-out-1314.google.com with SMTP id o4so445302uge for ; Wed, 25 Jul 2007 12:06:10 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=JEujV1tbgAQOERUYNrpsFz5AMk5fBoIG2RXZBksnfeGVHZiRTiY6mic/fqYY5ohlFiFLEqU0tuKPgq8mEiYjfEViSFgaKgFDr0PU3ZiSACE07YPnG++cvUcw94ctMMKt07AdGV8DZPPdJeOgFnk3I06vZy/BZVK9SFVXcN897Ig= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=KoYAumvfS62C1NeQM66UkJkLDrpF5Rk3utptaA7+LOggsO2+u/CmfUzPzmnzH2k3rTvD2YHfQlCAKSkeMiIPMuM7zOM1kdFbKGERNcdNcvZqkSohPpJ/j01Tqu7iIAKHyCheTgvwSGVB2hWVttFHDD4yOk6yJRTDGVHLeQfzB9Q= Received: by 10.86.60.7 with SMTP id i7mr642797fga.1185390370546; Wed, 25 Jul 2007 12:06:10 -0700 (PDT) Received: by 10.86.57.18 with HTTP; Wed, 25 Jul 2007 12:06:10 -0700 (PDT) Message-ID: <72cf361e0707251206l1baf0157x66a56501eafb4dfb@mail.gmail.com> Date: Wed, 25 Jul 2007 20:06:10 +0100 From: "Martin Hepworth" To: "Pat Maddox" In-Reply-To: <810a540e0707251052j6a1b2ac2jb61dd8af4efa083d@mail.gmail.com> MIME-Version: 1.0 References: <810a540e0707251052j6a1b2ac2jb61dd8af4efa083d@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-questions@freebsd.org Subject: Re: Having bad performance issues X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 25 Jul 2007 19:06:12 -0000 Pat I'd start by looking at tuning Postgresql....look at the queries that are taking the longest and optimise those. there's stuff alover the web about tuning PGsql On 7/25/07, Pat Maddox wrote: > > I'm having some bad perf issues on a 6.2 server running PostgreSQL > 8.2.4. I really don't know too much about this stuff...but it doesn't > seem to be related to memory or CPU as they're barely being touched. > Which leaves IO. Here's some vmstat output. My only guess is that the > numbers under the faults section are pretty high. But I don't really > know what that means. I'd appreciate any help. > > Here's the formatted vmstat output: http://pastie.caboo.se/82165 > > Pat > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to " > freebsd-questions-unsubscribe@freebsd.org" >