sizing / capacity planning tipps related to expected request or transactions per second

Поиск
Список
Период
Сортировка
От Dirk Krautschick
Тема sizing / capacity planning tipps related to expected request or transactions per second
Дата
Msg-id AM0PR05MB6082A57CCA80CBFFC16F08A1E9560@AM0PR05MB6082.eurprd05.prod.outlook.com
обсуждение исходный текст
Ответы Re: sizing / capacity planning tipps related to expected request or transactions per second  (MichaelDBA <MichaelDBA@sqlexec.com>)
Re: sizing / capacity planning tipps related to expected request or transactions per second  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-performance
Hi,

are there any nice rules of thumb about capacity planning in relation the expected
amount of transactions or request per second?

For example, if I have around 100 000 transactions per second on a 5 TB database.
With what amount of Memory and CPUs/Cores and which settings would you basically
Start to evaluate the performance.

Or are there any other recommendations or experiences here?

Thanks and best regards

Dirk

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

Предыдущее
От: Jim Jarvie
Дата:
Сообщение: Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
Следующее
От: MichaelDBA
Дата:
Сообщение: Re: sizing / capacity planning tipps related to expected request or transactions per second