Re: [HACKERS] Cached plans and statement generalization

2017-04-25 Thread Finnerty, Jim
On 4/25/17, 6:34 PM, "pgsql-hackers-ow...@postgresql.org on behalf of Andres Freund" wrote: It's not always that simple, at least in postgres, unless you disregard search_path. Consider e.g. cases like CREATE

Re: [HACKERS] Hash support for grouping sets

2017-01-16 Thread Finnerty, Jim
The ability to exploit hashed aggregation within sorted groups, when the order of the input stream can be exploited this way, is potentially a useful way to improve aggregation performance more generally. This would potentially be beneficial when the input size is expected to be larger than