Our indexes have accumulated over time, and some may not be necessary anymore. In addition to our own reasoning, and checking the git history for why they were added, we can get index usage statistics out Postgres from data gathered by PE support scripts to see which indexes are used most at customer sites. We should be sure to get scripts from multiple customers because their usage of PuppetDB may differ.
Our indexes have accumulated over time, and some may not be necessary anymore. In addition to our own reasoning, and checking the git history for why they were added, we can get index usage statistics out Postgres from data gathered by PE support scripts to see which indexes are used most at customer sites. We should be sure to get scripts from multiple customers because their usage of PuppetDB may differ.
Create tickets to remove any indexes we no longer need/want
Our indexes have accumulated over time, and some may not be necessary anymore. In addition to our own reasoning, and checking the git history for why they were added, we can get index usage statistics out Postgres from data gathered by PE support scripts to see which indexes are used most at customer sites. We should be sure to get scripts from multiple customers because their usage of PuppetDB may differ.
Create tickets to remove any indexes we no longer need