Window Customisation has not implemented caching

Description

issue: pg_stat_activity report in 2 hours hundred thousands of DB queries, instead use window customization in cache memory. At first look by - we identify no caching implemented over window customisations. The purpose of this effort is to identify how caching can be implemented, and as this is important done it before release 8.1.

Assumption
I assume when each window opening runs also window customizations (we are using it frequently), this should waste of DB CPU time and makes ZK reaction slower. Also i assume significant performance can be achieved by this issue improvement.

Norbert

Environment

private implementation, postgres 11.8 7.1z state sept 2. 2020

Assignee

Igor Pojzl

Reporter

Norbert Bede

Labels

Tested By

Norbert Bede

Priority

Major
Configure