Project

General

Profile

Config #6251

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

Added by Radko Krkoš 5 months ago.

Status:
New
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 columnsIn ProgressRadko Krkoš02/07/2020

Actions
#1

Updated by Radko Krkoš 5 months ago

  • Related to Bug #6211: Missing indices on aggregated columns added

Also available in: Atom PDF