Project

General

Profile

Bug #6211

Missing indices on aggregated columns

Added by Pavel Kácha 2 months ago. Updated about 2 months ago.

Status:
New
Priority:
Normal
Assignee:
Category:
Development - Database
Target version:
Start date:
02/07/2020
Due date:
% Done:

0%

Estimated time:
To be discussed:

Description

There are no indices on

  • source_ip_aggr_ip4
  • target_ip_aggr_ip4
  • source_ip_aggr_ip6
  • target_ip_aggr_ip6

on both mentat-hub and mentat-alt.

It might have vanished with some migration, anyway it doesn’t seem right.


Related issues

Related to Mentat - Config #6251: Rethink the indices and planner cost optimizations in light of the current usage patternsNew03/05/2020

History

#1 Updated by Jan Mach about 2 months ago

  • To be discussed changed from No to Yes

#2 Updated by Pavel Kácha about 2 months ago

  • To be discussed deleted (Yes)

Needs some more investigation (one index? more indices? works at all?)

#3 Updated by Radko Krkoš about 1 month ago

  • Related to Config #6251: Rethink the indices and planner cost optimizations in light of the current usage patterns added

Also available in: Atom PDF