Content-Length: 242686 | pFad | http://github.com/postgrespro/postgres_cluster/commit/8b49a6044d06b557047210dba2735081bb037e96

E1 Cache catalog lookup data across groups in ordered-set aggregates. · postgrespro/postgres_cluster@8b49a60 · GitHub
Skip to content

Commit 8b49a60

Browse files
tglsfdctglsfdc
committed
Cache catalog lookup data across groups in ordered-set aggregates.
The initial commit of ordered-set aggregates just did all the setup work afresh each time the aggregate function is started up. But in a GROUP BY query, the catalog lookups need not be repeated for each group, since the column datatypes and sort information won't change. When there are many small groups, this makes for a useful, though not huge, performance improvement. Per suggestion from Andrew Gierth. Profiling of these cases suggests that it might be profitable to avoid duplicate lookups within tuplesort startup as well; but changing the tuplesort APIs would have much broader impact, so I left that for another day.
1 parent 92459e7 commit 8b49a60

File tree

2 files changed

+290
-218
lines changed

2 files changed

+290
-218
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/8b49a6044d06b557047210dba2735081bb037e96

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy