SQL: PostgreSQL specific extensions

• Database Maintenance
  • CLUSTER
    • Sorts on disk relation in index order
    • Similar values close together, don't have to read extra pages
    
    
    • Before CLUSTER

  

  • After CLUSTER

  

  Prev

  Next

  Page 28