From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Vivek Khera <vivek@khera.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: getting count for a specific querry
Date: Tue, 12 Apr 2005 15:23:07 -0500
Message-ID: <1113337387.20921.413.camel@state.g2switchworks.com> (raw)
In-Reply-To: <f6b84e33b966209319d594a66dba0741@khera.org>
References: <003b01c53c70$6ff184b0$797ba8c0@jfradkin>
<cb3b9f9319ae75a9f8eb756ff38e85e8@khera.org>
<762e5c05040813354436bd27@mail.gmail.com>
<8ef5bfe4806dac39bab8e07837dbab38@khera.org>
<1112993454.20921.89.camel@state.g2switchworks.com>
<f6b84e33b966209319d594a66dba0741@khera.org>
On Tue, 2005-04-12 at 14:29, Vivek Khera wrote:
> On Apr 8, 2005, at 4:50 PM, Scott Marlowe wrote:
>
> > Do you run your 2650s with hyperthreading on? I found that slowed mine
> > down under load, but we never had more than a couple dozen users
> > hitting
> > the db at once, so we may well have had a different load profile than
> > what you're seeing.
> >
>
> Yep. Turned off as per various recommendations on this list. The RAID
> card on this box is a PERC 3/DC. It is a very big disappointment. The
> Opteron based generic system totally outperforms this Dell box.
How much memory is in the box? I've heard horror stories about
performance with >2 gigs of ram, which is why I made them order mine
with 2 gigs. Does the 3/DC have battery backed cache set to write back?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, vivek@khera.org
Subject: Re: getting count for a specific querry
In-Reply-To: <1113337387.20921.413.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox