Project

General

Profile

Actions

Config #6251

open

Rethink the indices and planner cost optimizations in light of the current usage patterns

Added by Radko Krkoš about 4 years ago. Updated over 1 year ago.

Status:
Deferred
Priority:
Normal
Assignee:
Category:
Design
Target version:
Start date:
03/05/2020
Due date:
% Done:

0%

Estimated time:
To be discussed:
No

Description

When the Mentat was migrated to PotgreSQL, the DB was version 9.6. The current version is v12, with v13 nearing. Tremendous amount of work was done upstream in the database, many of the premises valid then are no longer true. Also, the capabilities of Mentat grew in ways not foreseen or at least not originally intended (thanks to CTI).
We need to go back to drawing board, analyze the analytics processing needs of current Mentat, the processing capabilities of current PostgreSQL, and come up with a new database configuration and indexing schema, addressing the new requirements.


Related issues

Related to Mentat - Bug #6211: Missing indices on aggregated columnsClosedPavel Kácha02/07/2020

Actions
Related to Mentat - Feature #6413: Autarkic DB queries for timelineClosedJakub Maloštik07/07/2020

Actions
Actions

Also available in: Atom PDF