Re: EXPLAIN BUFFERS

Поиск
Список
Период
Сортировка
От Takahiro Itagaki
Тема Re: EXPLAIN BUFFERS
Дата
Msg-id 20091214123400.8A89.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: EXPLAIN BUFFERS  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: EXPLAIN BUFFERS
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp> writes:
> > Should I add countBufferUsage boolean arguments to all places
> > doInstrument booleans are currently used? This requires several
> > minor modifications of codes in many places.
> 
> Pushing extra arguments around would create overhead of its own ...
> overhead that would be paid even when not using EXPLAIN at all.

I cannot understand what you mean... The additional argument should
not be a performance overhead because the code path is run only once
per execution. Instrumentation structures are still not allocated
in normal or EXPLAIN queries; allocated only in "EXPLAIN ANALYZE".

Or, are you suggesting to separate buffer counters with Instrumentation
structure? It still requires extra arguments, but it could minimize the
overhead when we use EXPLAIN ANALYZE without BUFFERS. However, we need
additional codes around InstrStartNode/InstrStopNode calls.

Or, are you complaining about non-performance overheads,
something like overheads of code maintenance?

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center




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

Предыдущее
От: daveg
Дата:
Сообщение: Re: pg_dump enhancement proposal
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Streaming replication and non-blocking I/O