Re: getting count for a specific querry

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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Query history file
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: getting count for a specific querry