Re: Server Performance

On Tue, 31 Mar 2009, Chris(dot)Ellis(at)shropshire(dot)gov(dot)uk wrote:

> Been having interesting times with an IBM x3650 with 8 15k RPM 73GB
> drives in RAID 10 and a ServRAID 8K controller with Write-Back cache
> enabled (battery installed and working).  Currently getting a pgbench
> score of 4.7 transactions per second!

pgbench is a very high level test of your system. It can tell you when a
system is doing well, but it's almost useless for figuring out what's
wrong if there's a problem.

You shouldn't run pgbench until you've first done a lower-level benchmark
such as bonnie++ on the hardware. That should give you a better idea
what's going on here, and if the badness shows up there it will be much
easier to get someone at IBM to pay attention too.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>From pgsql-general-owner(at)postgresql(dot)org Tue Mar 31 18:21:52 2009
Received: from localhost (unknown [200.46.208.211])
by mail.postgresql.org (Postfix) with ESMTP id 16744635157
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>; Tue, 31 Mar 2009 17:10:53 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
with ESMTP id 02444-09
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>;
Tue, 31 Mar 2009 17:10:47 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f176.google.com (mail-gx0-f176.google.com [209.85.217.176])
by mail.postgresql.org (Postfix) with ESMTP id 935D9635126
for <pgsql-general(at)postgresql(dot)org>; Tue, 31 Mar 2009 17:10:51 -0300 (ADT)
Received: by gxk24 with SMTP id 24so7650339gxk.19
for <pgsql-general(at)postgresql(dot)org>; Tue, 31 Mar 2009 13:10:50 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:date:received:message-id:subject
:from:to:content-type;
bh=xKXngZmZXW2Ri47mTMnc0AEUTsdNmYzG6hMO0q5bhmk=;
b=xJgxe1KM/0NKTnCnkcxhVARvsMXFxYeVx6caQLcIhi/xyt6xGaKwLOql2dOQvvMjky
89PJ42P48MRibHjmGDuXYD7EpDGHoz3UmGwCMQkJtYtki4fOYgdpYHJ0xkyOvmbje1xD
QeDOzpYZfKQ/LbRbbnAs5IjEhawtW5thQ06B4=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:date:message-id:subject:from:to:content-type;
b=TdaycuYT5oVAbLVI/ONdT1p/pdFQ34mM0Zs13bi3wAvHlW5k4/0vxELvz7uz7HoJyO
dzVck7i03QCVzEbckPBw8g+kU1sBchlbRD33cPWdqHB3vX/3NoQh27c8nfT47UQB8QaW
2MGdFCVxy/o1BxJp42MK1hJu6PlUP+wNQmcRY=
MIME-Version: 1.0
Date: Tue, 31 Mar 2009 16:10:35 -0400
Received: by 10.150.156.9 with SMTP id d9mr13286152ybe.182.1238530250515; Tue,
31 Mar 2009 13:10:50 -0700 (PDT)
Message-ID: <aaff70a90903311310u429e8722y420540da40d36312(at)mail(dot)gmail(dot)com>
Subject: =?windows-1252?Q?ERROR=3A_XX001=3A_could_not_read_block_2354_of_relation?=
=?windows-1252?Q?=85?=
From: Patrick Desjardins <mrdesjardins(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Content-Type: multipart/alternative; boundary=000e0cd6b21aa02e3104666fcbe9
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
tests=HTML_MESSAGE=0.001
X-Spam-Level:
X-Archive-Number: 200903/1362
X-Sequence-Number: 145948

--000e0cd6b21aa02e3104666fcbe9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi,

I have the error ERROR: XX001: could not read block 2354 of relation
1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when trying
to Insert data into a table. I would say that 99% of Insert works and 100%
of read works. This is only happenning since few weeks. I have done Vaccum
Analyze without any success (the vaccum take 65 minutes but nothing is
fixed, still have the ERROR XXX001). I have this error in the backend
application and when I do some Insert Query in the PgAdmin tool.

What can I do to fix that problem?

Thank you,

--000e0cd6b21aa02e3104666fcbe9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<br><br>I have the error ERROR: XX001: could not read block 2354 of rela=
tion 1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when t=
rying to Insert data into a table. I would say that 99% of Insert works and=
100% of read works. This is only happenning since few weeks. I have done V=
accum Analyze without any success (the vaccum take 65 minutes but nothing i=
s fixed, still have the ERROR XXX001). I have this error in the backend app=
lication and when I do some Insert Query in the PgAdmin tool.<br>

<br>What can I do to fix that problem?<br><br>Thank you,<br>

--000e0cd6b21aa02e3104666fcbe9--