Here are a few extra tips: - "select relname, indexrelname, idx_scan from pg_stat_user_indexes" will show how many times an index is used, so you can remove un

Here are a few extra tips: - "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