- "select relname, indexrelname, idx_scan from pg_stat_user_indexes" will show how many times an index is used, so you can remove unused indexes
- you can create indexes without locking tables (ie, while your site is up) by using "create index concurrently"
- you should use the autovaccuum daemon instead of manually running vacuum analyze in most cases
- "select relname, indexrelname, idx_scan from pg_stat_user_indexes" will show how many times an index is used, so you can remove unused indexes
- you can create indexes without locking tables (ie, while your site is up) by using "create index concurrently"
- you should use the autovaccuum daemon instead of manually running vacuum analyze in most cases