| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Vivek Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: getting count for a specific querry |
| Date: | 2005-04-12 20:23:07 |
| Message-ID: | 1113337387.20921.413.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2005-04-12 20:32:18 | Re: getting count for a specific querry |
| Previous Message | Vivek Khera | 2005-04-12 19:33:36 | Re: Query history file |