Re: getting count for a specific querry - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: getting count for a specific querry
Date
Msg-id 1113338574.20921.436.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: getting count for a specific querry  (Vivek Khera <vivek@khera.org>)
List 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.


pgsql-sql by date:

Previous
From: Vivek Khera
Date:
Subject: Re: getting count for a specific querry
Next
From: "Andrus"
Date:
Subject: Re: Query runs very slowly in Postgres, but very fast in other DBMS