Re: Show lossy heap block info in EXPLAIN ANALYZE for bitmap heap scan - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Show lossy heap block info in EXPLAIN ANALYZE for bitmap heap scan
Date
Msg-id 00a901cf0db8$04e2a6e0$0ea7f4a0$@etsuro@lab.ntt.co.jp
Whole thread Raw
In response to Re: Show lossy heap block info in EXPLAIN ANALYZE for bitmap heap scan  ("Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>)
List pgsql-hackers
I wrote:
> Robert Haas wrote:
> > Hmm, fair point.  But I'm still not convinced that we really need to
> > add extra accounting for this.  What's wrong with just reporting the
> > number of exact and lossy pages?

> No.  I intended to show the desired memory space for a TIDBitmap rather
> than the peak memory usage for that TIDBitmap.  And I thought it'd be
better
> for the latter to be displayed as additional information.  However, I've
> removed the functionality for showing the desired memory space due to
> technical problems.  Now I should probably remove the functionality for
> showing the peak memory usage too.

> Yes, as Andres mentioned, showing the peak memory usage is not a bad idea,
> I think.  But I start to think it's not necessarily worth complicating the
> code ...

> If there are no objections of others, I'll remove extra accounting for
> showing the peak memory usage.

Done.  Please find attached a patch.

Thanks,

Best regards,
Etsuro Fujita

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
Next
From: Amit Kapila
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters