Extensions

• Adaptive Query Optimiser (AQO)
  Here, we employ that database systems usually process queries of quite similar structure. The main idea is to save information about the actual number of rows produced by query plan nodes and reuse it during the subsequent execution. Two significant hurdles were managed here. First, some node signatures were invented to match cardinality and specific nodes during planning. Second, how to generalise the knowledge base.

• pg_index_stats
  The rationale of this project is the conjecture that the index structure reflects a pattern of the most frequent and vital queries. Therefore, we are waiting for indexed columns to be used more intensively. Query plans, including these columns in filter clauses and aggregate operations, should be optimised more eagerly with fewer prediction errors. So, compound statistics on such columns would be essential, even though they may cause additional planning and table maintenance overhead.

• pg_track_optimiser

  This project aims to find out poorly planned queries in the vast flow of incoming queries.

We participate in the PGEDC community.