Re: Performance under contention - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Performance under contention
Date
Msg-id 4CEA58430200002500037D06@gw.wicourts.gov
Whole thread Raw
In response to Performance under contention  (Ivan Voras <ivoras@freebsd.org>)
Responses Re: Performance under contention
List pgsql-performance
Ivan Voras <ivoras@freebsd.org> wrote:

> It looks like a hack

Not to everyone.  In the referenced section, Hellerstein,
Stonebraker and Hamilton say:

"any good multi-user system has an admission control policy"

In the case of PostgreSQL I understand the counter-argument,
although I'm inclined to think that it's prudent for a product to
limit resource usage to a level at which it can still function well,
even if there's an external solution which can also work, should
people use it correctly.  It seems likely that a mature admission
control policy could do a better job of managing some resources than
an external product could.

-Kevin

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Performance under contention
Next
From: Humair Mohammed
Date:
Subject: Re: Query Performance SQL Server vs. Postgresql