Re: Explain buffers display units.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Explain buffers display units.
Дата
Msg-id 603c8f071002150622n78de9c73gf32d89306c8f3b07@mail.gmail.com
обсуждение исходный текст
Ответ на Explain buffers display units.  (Greg Stark <stark@mit.edu>)
Ответы Re: Explain buffers display units.  (Greg Stark <stark@mit.edu>)
Список pgsql-hackers
On Sun, Feb 14, 2010 at 8:25 PM, Greg Stark <stark@mit.edu> wrote:
> So this is what I did about my two complaints earlier about the
> explain buffer patch.
>
> a) Changed the line description to "Total Buffer Usage" which at least
> hints that it's something more akin to the "Total runtime" listed at
> the bottom than the "actual time".
>
> b) Used units of memory -- I formatted them with 3 significant digits
> (unless the unit is bytes or kB where that would be silly). It's just
> what looked best to my eye.

I wasn't aware we had consensus on making this change, which I see you
committed less than an hour after posting this.

> I'm finding "hit" and "read" kind of confusing myself but don't really
> have any better idea. It's not entirely clear whether read is the
> total accesses out of which some are cache hits or if they're two
> disjoint sets.

Keep in mind these terms are taken from other parts of the system
where they existed prior to this patch.  We probably want to stick
with them at this point for consistency, but in any case it's
certainly a separate discussion.

...Robert


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after
Следующее
От: Robert Haas
Дата:
Сообщение: alpha4 timing (was: Speed up CREATE DATABASE)