From owner-freebsd-questions@FreeBSD.ORG Wed Jul 25 17:52:41 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 7BC1416A418 for ; Wed, 25 Jul 2007 17:52:41 +0000 (UTC) (envelope-from pergesu@gmail.com) Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.177]) by mx1.freebsd.org (Postfix) with ESMTP id 05B9513C4DE for ; Wed, 25 Jul 2007 17:52:40 +0000 (UTC) (envelope-from pergesu@gmail.com) Received: by ik-out-1112.google.com with SMTP id c21so237410ika for ; Wed, 25 Jul 2007 10:52:39 -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:mime-version:content-type:content-transfer-encoding:content-disposition; b=Ulbl6aI182bstXqx3hM1gL1rMkeLqdKCkfDdMpZTiUrW4VaCyqm6jBSY86g21uPAoVSumSRAZ4lefdBCv30+K/412TPUPNAN+hJIAbav4rmeQE6/6R2IVDbZrNle3CyjLqIbqR+Nxl4jbP4PEFoBypAGLUnqjiexLq8YoIv6mug= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Zp8r/wk291c2TYV4kQ4MhAYbnFjfM4scBhx4lqKi/ORRTmQ+5PSEmhlCw+dmcpCTJVqgqU67HT1HRSPxYAsE2yPSS3K7TDeb9+MiXA6tU7Y4fy7cD5J1lYFX4axjLECuDESL+PDYHCY2dKQG204zgXaqodF8PDZLcbh2bOaIRJA= Received: by 10.78.168.1 with SMTP id q1mr226640hue.1185385958253; Wed, 25 Jul 2007 10:52:38 -0700 (PDT) Received: by 10.78.200.15 with HTTP; Wed, 25 Jul 2007 10:52:38 -0700 (PDT) Message-ID: <810a540e0707251052j6a1b2ac2jb61dd8af4efa083d@mail.gmail.com> Date: Wed, 25 Jul 2007 11:52:38 -0600 From: "Pat Maddox" To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: 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 17:52:41 -0000 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