Re: I/O timigns don't include time for temp buffers

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: I/O timigns don't include time for temp buffers
Date: 2021-08-11 08:35:40
Message-ID: 20210811083540.GA24169@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Aug 10, 2021 at 03:15:27PM +0900, Masahiko Sawada wrote:
> > This shows that the Hash wrote 1100 temp buffers, but I/O timings didn't increase at all.
> Yes, we don't collect the time spent reading and writing temp files.

And this is the source of my concern.

Not that we have this documented in one way or another, but why exactly
aren't we taking temp buffers into timing? There are cases where it is
the temp buffers IO that is using most of the time.

Best regards,

depesz

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message talk to ben 2021-08-11 13:41:25 Re: BUG #17061: Impossible to query the fields of the tuple created by SEARCH BREADTH FIRST BY .. SET ..
Previous Message Juan José Santamaría Flecha 2021-08-11 07:44:03 Re: BUG #17138: account set up and password problems