The main idea of this project is an analysis of DB performance. Here is a looking at different performance cases in different business contexts.
- BRIN index Analyze
- BTREE index Analyze
- GIN index Analyze
- GIST index Analyze
- HASH index Analyze
- SP-GIST index Analyze
- Indexes overload
- Vertical sharding - split table to several separated
- Horizontal - split DB to several instances
As an initial DB implemented in file
Contains a couple of tables, domain is company's recruitment, couple functions and triggers.
Every package of analysis contains extension for database. It is required to represent real enterprise cases where indexes and sharding is necessity, not option