deep-foundation / deep-foundation/deeplinks

Dynamic PostgreSQL indexes

Open
#28 0 comments 0 reactions 1 assignee Claimed by @konard View on GitHub
Dominant language
TypeScript
Stars
13
Forks
8
PR merge metrics
No merged PRs in 30d

Description

1. Create all indexes for all columns in the table: https://gist.github.com/Konard/8d2866bcc55192aa24c887b40553419d
2. Collect indexes usage statistics
3. Collect statistics about executed queries
4. Translate statistics from 2 and 3 steps into sequences of columns that are used and their usage frequency (https://github.com/Konard/LinksPlatform/issues/589 can be related)
5. Once in the moment of time, use N most frequent sequences of columns as combined indexes, all other combined indexes that are not in whitelist are deleted.

This way we get dynamic adaptation of indexes to queries and indexes usage statistics.

There should be setting that is updatable by user for changing the number of indexes used versus write speed and storage space used.

This way the user will be able to adjust what is more important to have good write speed or to have good read speed.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.