Re: Trouble with hashagg spill I/O pattern and costing

From:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To:	Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc:	Jeff Davis <pgsql(at)j-davis(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject:	Re: Trouble with hashagg spill I/O pattern and costing
Date:	2020-06-05 21:19:43
Message-ID:	20200605211943.GA5265@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-05-19 15:12:02 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎  2020-05-19 16:27:34 from Jeff Davis <pgsql(at)j-davis(dot)com>   2020-05-19 17:53:20 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>    2020-05-20 04:15:40 from Jeff Davis <pgsql(at)j-davis(dot)com> 📎     2020-05-21 00:12:55 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>      2020-05-21 14:45:10 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>       2020-05-21 17:05:25 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-05-21 19:13:18 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>      2020-05-21 19:40:23 from Jeff Davis <pgsql(at)j-davis(dot)com>       2020-05-21 21:02:32 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>      2020-05-21 21:16:37 from Jeff Davis <pgsql(at)j-davis(dot)com> 📎       2020-05-21 21:41:22 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>        2020-05-25 02:10:45 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎         2020-05-25 12:17:22 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎          2020-05-25 19:49:45 from Jeff Davis <pgsql(at)j-davis(dot)com>           2020-05-25 22:59:09 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>            2020-05-26 05:02:41 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>             2020-05-26 14:15:24 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎              2020-05-26 18:40:07 from Jeff Davis <pgsql(at)j-davis(dot)com>               2020-05-26 19:15:11 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                2020-05-27 00:40:19 from Jeff Davis <pgsql(at)j-davis(dot)com>                 2020-05-27 01:42:50 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                  2020-05-27 09:07:04 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                   2020-05-28 18:57:50 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                    2020-05-29 01:14:55 from Jeff Davis <pgsql(at)j-davis(dot)com>                     2020-05-29 13:04:54 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                      2020-05-29 20:12:40 from Jeff Davis <pgsql(at)j-davis(dot)com>                      2020-06-05 21:19:43 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                       2020-06-05 22:20:57 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                        2020-06-05 22:51:34 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                         2020-06-05 23:17:26 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                 2020-05-29 00:48:11 from Jeff Davis <pgsql(at)j-davis(dot)com> 📎         2020-05-25 18:36:42 from Jeff Davis <pgsql(at)j-davis(dot)com>          2020-05-25 22:04:07 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>  2020-05-21 13:41:22 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>   2020-05-21 14:30:40 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎    2020-05-21 18:19:01 from Jeff Davis <pgsql(at)j-davis(dot)com>     2020-05-21 18:34:05 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>      2020-05-21 18:54:59 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>       2020-05-21 19:04:19 from Jeff Davis <pgsql(at)j-davis(dot)com>        2020-05-21 19:17:39 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Lists:	pgsql-hackers

In response to

• Re: Trouble with hashagg spill I/O pattern and costing at 2020-05-29 13:04:54 from Tomas Vondra

Responses

• Re: Trouble with hashagg spill I/O pattern and costing at 2020-06-05 22:20:57 from Tomas Vondra

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2020-06-05 21:49:17	Re: v13: Performance regression related to FORTIFY_SOURCE
Previous Message	Thomas Munro	2020-06-05 21:15:14	Re: WIP: WAL prefetch (another approach)