Re: Write workload is causing severe slowdown in Production

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Re: Write workload is causing severe slowdown in Production
Дата
Msg-id 00b601cd0824$c8dfd6d0$5a9f8470$@com
обсуждение исходный текст
Ответ на Re: Write workload is causing severe slowdown in Production  ("Tomas Vondra" <tv@fuzzy.cz>)
Ответы Re: Write workload is causing severe slowdown in Production  ("Gnanakumar" <gnanam@zoniac.com>)
Re: Write workload is causing severe slowdown in Production  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-performance
> So, what else is running on the system? Because if there's 35GB RAM and
> the shared buffers are 1.5GB, then there's about 33GB for page cache.
> Something like 16GB would be a conservative setting.

Yes, you guessed it right.  Both Web server and DB server are running in the same machine.

> I'm not saying this will fix the issues, but maybe it shows that something
> else is running on the box and maybe that's the culprit, not PostgreSQL?

Based on my observations and analysis, I'm sure that database write operation "is" causing the slowdown, but not
becauseof other applications running in the same server. 

> Then install the app again and collect as much info as possible. Otherwise
> it's all just wild guesses.

OK.



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

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Write workload is causing severe slowdown in Production
Следующее
От: "Gnanakumar"
Дата:
Сообщение: Re: Write workload is causing severe slowdown in Production