Postgres Pro
Downloads
Home   >   mailing lists

Re: Default setting for enable_hashagg_disk - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Default setting for enable_hashagg_disk
Date
Msg-id da1c96f1b16ae6b36cb5325396dfb901a5f6d3e6.camel@j-davis.com
Whole thread Raw
In response to Re: Default setting for enable_hashagg_disk  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Fri, 2020-07-24 at 21:16 +0200, Tomas Vondra wrote:
> Surely more recursive spilling should do more I/O, but the Disk Usage
> reported by explain analyze does not show anything like ...

I suspect that's because of disk reuse in logtape.c. 

Regards,
    Jeff Davis

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: INSERT INTO SELECT, Why Parallelism is not selected?
Next
From: Peter Geoghegan
Date:
Subject: Re: Default setting for enable_hashagg_disk