Re: Cost limited statements RFC

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Cost limited statements RFC
Дата
Msg-id CAMkU=1xbobgH7+BvVzR1c+GApQiiaaQT84uX-byLW-0L5RKkgw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cost limited statements RFC  (Greg Smith <greg@2ndQuadrant.com>)
Ответы Re: Cost limited statements RFC  (Robert Haas <robertmhaas@gmail.com>)
Re: Cost limited statements RFC  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
On Fri, May 24, 2013 at 11:51 AM, Greg Smith <greg@2ndquadrant.com> wrote:
On 5/24/13 9:21 AM, Robert Haas wrote:

But I wonder if we wouldn't be better off coming up with a little more
user-friendly API.  Instead of exposing a cost delay, a cost limit,
and various charges, perhaps we should just provide limits measured in
KB/s, like dirty_rate_limit = <amount of data you can dirty per
second, in kB> and read_rate_limit = <amount of data you can read into
shared buffers per second, in kB>.

I already made and lost the argument for doing vacuum in KB/s units, so I wasn't planning on putting that in the way of this one.  

I think the problem is that making that change would force people to relearn something that was already long established, and it was far from clear that the improvement, though real, was big enough to justify forcing people to do that.  That objection would not apply to a new feature, as there would be nothing to re-learn.  The other objection was that (at that time) we had some hope that the entire workings would be redone for 9.3, and it seemed unfriendly to re-name things in 9.2 without much change in functionality, and then redo them completely in 9.3.

Cheers,

Jeff

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [PATCH]Tablesample Submission
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Redesigning checkpoint_segments