Re: getting count for a specific querry

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: getting count for a specific querry
Дата
Msg-id 1113338574.20921.436.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: getting count for a specific querry  (Vivek Khera <vivek@khera.org>)
Список 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 по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: getting count for a specific querry
Следующее
От: "Andrus"
Дата:
Сообщение: Re: Query runs very slowly in Postgres, but very fast in other DBMS