Re: Performance issue with Insert

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Performance issue with Insert
Дата
Msg-id 4E08EC67.6090304@fuzzy.cz
обсуждение исходный текст
Ответ на Re: Performance issue with Insert  (Jenish <jenishvyas@gmail.com>)
Список pgsql-performance
Dne 27.6.2011 22:14, Jenish napsal(a):
>  And I am testing the limit for the concurrent active users. When I am
> running my test for 400 concurrent user ie. Active connection. I am
> getting good performance but when I am running the same the same test
> for 950 concurrent users I am getting very bad performance.

This is typical behaviour - the performance is good up until some point,
then it degrades much faster.

Why do you even need such number of connections? Does that really
improve performance (e.g. how many inserts do you do with 100 and 400
connections)?

Such number of active connections is not going to give you any advantage
I guess ...

regards
Tomas

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

Предыдущее
От: Jenish
Дата:
Сообщение: Re: Performance issue with Insert
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Performance issue with Insert