| From: | serge(at)rielau(dot)com |
|---|---|
| To: | "Tomas Vondra" <tomas(dot)vondra(at)2ndquadrant(dot)com>, "David Rowley" <david(dot)rowley(at)2ndquadrant(dot)com>, "Andres Freund" <andres(at)anarazel(dot)de> |
| Cc: | "Heikki Linnakangas" <hlinnaka(at)iki(dot)fi>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>, "Jeff Davis" <pgsql(at)j-davis(dot)com> |
| Subject: | RE: Re: Spilling hashed SetOps and aggregates to disk |
| Date: | 2018-06-05 13:41:45 |
| Message-ID: | 20180605064145.9cf3801d03770ada01bb39dc8f52321d.e7845a4b75.mailapi@email18.godaddy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
In our code base we have added a WithStats-Flavor for creating memory contexts.
This api accepts a pointer to metric for accounting and it is inherited by all subcontexts unless overridden.
So we only needed to change context creation API where we wanted (such as TopTansactionContext, Message Context, ..)
That's quite trivial, actually.
Also we have fixed all those missing hash spills - albeit based on the 9.6 hash table design I think.
If there is interest by the community we are very willing to share.
Cheers
Serge
Salesforce
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2018-06-05 13:45:19 | Locking B-tree leafs immediately in exclusive mode |
| Previous Message | Ashutosh Bapat | 2018-06-05 13:39:24 | Re: why partition pruning doesn't work? |