Just as an update, We installed RHE Update4 beta kernel on a box and it
seems to have solved our issues.
Woody
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3550 x813
www.iglass.net
---(end of broadcast)--
, 2004 4:22 PM
To: [EMAIL PROTECTED]
Subject: Re: [PERFORM] Query Performance and IOWait
The data that we are accessing is via QLogic cards connected to an EMC
Clarion. We have tried it on local SCSI disks with the same (bad)
results.
When the machine gets stuck in a 100% IOWAIT state it often crashes
: Thursday, November 18, 2004 11:14 AM
To: Andrew Janian
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] Query Performance and IOWait
Andrew,
Dell's aren't well known for their disk performance, apparently most of
the perc controllers sold with dell's are actually adaptec controllers.
On Thu, 18 Nov 2004 12:14:00 -0500
Dave Cramer <[EMAIL PROTECTED]> wrote:
> Andrew,
>
> Dell's aren't well known for their disk performance, apparently most
> of the perc controllers sold with dell's are actually adaptec
> controllers. Also apparently they do not come with the battery
> required
PM
To: [EMAIL PROTECTED]
Cc: Woody Woodring; 'Andrew Janian'
Subject: Re: [PERFORM] Query Performance and IOWait
Woody,
> What version of Redhat are you running? We have found running
> Enterprise Update 3 kernel kills our Dell boxes with IOWait, both NFS
> and local disk
Woody,
> What version of Redhat are you running? We have found running Enterprise
> Update 3 kernel kills our Dell boxes with IOWait, both NFS and local disk
> traffic. Update 2 kernel does not seem to have the issue, and we are in
> the process of trying Update 4 beta to see if it is better.
Andrew,
Dell's aren't well known for their disk performance, apparently most of
the perc controllers sold with dell's are actually adaptec controllers.
Also apparently they do not come with the battery required to use the
battery backed up write cache ( In fact according to some Dell won't
even
To: Andrew Janian
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] Query Performance and IOWait
"Andrew Janian" <[EMAIL PROTE
all your help,
Andrew
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 18, 2004 9:40 AM
To: Andrew Janian
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] Query Performance and IOWait
"Andrew Janian" <[EMAIL PROTE
"Andrew Janian" <[EMAIL PROTECTED]> writes:
>
>
>
>
.
Woody
iGLASS Networks
www.iglass.net
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Janian
Sent: Thursday, November 18, 2004 9:02 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PERFORM] Query Performance and IOWait
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, November 18, 2004 7:57 AM
To: Andrew Janian
Cc: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [PERFORM] Query Performance and IOWait
Andrew,
It seems that you could combine the subquery's WHERE clause with the main
query&#x
:
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: [PERFORM] Query
Performance and IOWait
Hello All,
I have a setup with a Dell Poweredge 2650 with Red Hat and Postgres 7.4.5 with
a database with about 27GB of data. The table in question has about 35 million
rows.
I am running the following query:
SELECT *
FROM mb_fix_message
WHERE msg_client_order_id IN (
SELECT msg_clien
14 matches
Mail list logo
