Re: getting count for a specific querry

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:42:54
Message-ID: 1113338574.20921.436.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 2005-04-12 at 15:32, Vivek Khera wrote:
> On Apr 12, 2005, at 4:23 PM, Scott Marlowe wrote:
>
> > 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?
> >
>
> 4GB RAM and battery backed cache set to write-back mode. FreeBSD 4.11.

If you've got the time, try running it with only 2 gigs and compare the
speed. I never really got a chance to run mine with >2 gigs, but I know
that I read plenty of posts at the time that the chipset in the 2650 was
REALLY slow at using memory over 2 gig.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message jspring 2005-04-13 02:46:03 ignore single character in SELECT query?
Previous Message Vivek Khera 2005-04-12 20:32:18 Re: getting count for a specific querry