SQL: PostgreSQL specific extensions

• Database maintenance
  • VACUUM [FULL] [table]
  • Reclaim dead-tuples

• ANALYZE [table]
• Data for planner: number of tuples, number of NULLs in the column, average width in bytes, number of distinct values, more complicated statistics


• REINDEX

Page 27