Re: Performance under contention

Список
Период
Сортировка
От Kevin Grittner
Тема Re: Performance under contention
Дата
Msg-id 4CEA373D0200002500037CED@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Performance under contention  (Ivan Voras)
Ответы Re: Performance under contention  (Ivan Voras)
Список pgsql-performance
Дерево обсуждения
Performance under contention  (Ivan Voras, )
 Re: Performance under contention  ("Kevin Grittner", )
  Re: Performance under contention  (Ivan Voras, )
   Re: Performance under contention  (Jignesh Shah, )
    Re: Performance under contention  (Omar Kilani, )
   Re: Performance under contention  ("Kevin Grittner", )
    Re: Performance under contention  (Ivan Voras, )
     Re: Performance under contention  (Craig Ringer, )
      Re: Performance under contention  (Ivan Voras, )
      Re: Performance under contention  (Vitalii Tymchyshyn, )
       Re: Performance under contention  ("Kevin Grittner", )
 Re: Performance under contention  ("Kevin Grittner", )
  Re: Performance under contention  (Ivan Voras, )
 Re: Performance under contention  (Greg Smith, )
  Re: Performance under contention  (Ivan Voras, )
 Re: Performance under contention  (Robert Haas, )
  Re: Performance under contention  (Robert Haas, )
  Re: Performance under contention  (Jignesh Shah, )
   Re: Performance under contention  (Jignesh Shah, )
   Re: Performance under contention  (Robert Haas, )
    Re: Performance under contention  (Tom Lane, )
     Re: Performance under contention  (Dave Crooke, )
     Re: Performance under contention  (Robert Haas, )
    Re: Performance under contention  (Ivan Voras, )
     Re: Performance under contention  (Robert Haas, )
      Re: Performance under contention  (Ivan Voras, )
      Re: Performance under contention  (Віталій Тимчишин, )
       Re: Performance under contention  (Ivan Voras, )
       Re: Performance under contention  (Robert Haas, )
        Re: Performance under contention  (Robert Haas, )
         Re: Performance under contention  (Tom Lane, )
          Re: Performance under contention  (Robert Haas, )
           Re: Performance under contention  (Tom Lane, )
            Re: Performance under contention  (Robert Haas, )
Ivan Voras <> wrote:
> On 11/22/10 02:47, Kevin Grittner wrote:
>> Ivan Voras  wrote:
>>
>>> After 16 clients (which is still good since there are only 12
>>> "real" cores in the system), the performance drops sharply
>>
>> Yet another data point to confirm the importance of connection
>> pooling.  :-)
>
> I agree, connection pooling will get rid of the symptom. But not
> the underlying problem. I'm not saying that having 1000s of
> connections to the database is a particularly good design, only
> that there shouldn't be a sharp decline in performance when it
> does happen. Ideally, the performance should remain the same as it
> was at its peek.

Well, I suggested that we add an admission control[1] mechanism,
with at least part of the initial default policy being that there is
a limit on the number of active database transactions.  Such a
policy would do what you are suggesting, but the idea was shot down
on the basis that in most of the cases where this would help, people
would be better served by using an external connection pool.

If interested, search the archives for details of the discussion.

-Kevin

[1] http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf
Joseph M. Hellerstein, Michael Stonebraker and James Hamilton. 2007.
Architecture of a Database System. Foundations and Trends(R) in
Databases Vol. 1, No. 2 (2007) 141*259
(see Section 2.4 - Admission Control)

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Performance under contention
Следующее
От: Humair Mohammed
Дата:
Сообщение: Re: Query Performance SQL Server vs. Postgresql