ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation
Tutorial on what happens when you create an index in a database. Trade offs to be aware of while creating an index and how to use it efficiently.| www.startdataengineering.com
The BUFFERS option to Postgres' EXPLAIN command can help you work out where queries are using lots of IO. learn how to use this to optimize your SQL.| willj.net