Re: PostgreSQL strugling during high load

Поиск
Список
Период
Сортировка
От Anjan Dave
Тема Re: PostgreSQL strugling during high load
Дата
Msg-id 4BAFBB6B9CC46F41B2AD7D9F4BBAF785026FF87E@vt-pe2550-001.vantage.vantage.com
обсуждение исходный текст
Ответ на PostgreSQL strugling during high load  ("Mindaugas Riauba" <mind@bi.lt>)
Список pgsql-performance
Yes, I am using it another DB/application. Few more days and I'll have a
free hand on this box as well.

Thanks,
Anjan

-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com]
Sent: Thursday, May 19, 2005 3:58 PM
To: Anjan Dave
Cc: Donald Courtney; Tom Lane; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] PostgreSQL strugling during high load

Anjan,

> As far as disk I/O is concerned for flushing the buffers out, I am not
> ruling out the combination of Dell PERC4 RAID card, and the RH AS 3.0
> Update3 being a problem.

You know that Update4 is out, yes?
Update3 is currenly throttling your I/O by about 50%.

--

--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


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

Предыдущее
От: Steve Poe
Дата:
Сообщение: Re: PostgreSQL strugling during high load
Следующее
От: Jeffrey Tenny
Дата:
Сообщение: Which is better, correlated subqueries or joins?