Database System Tuning

• Touch on lightly: (other talks)
   
• $PGDATA/postgresql.conf:
   
  • fsync() (bulk loads)
     
  • sort_mem - default is only 1M, set much higher depending on queries/RAM
     
  • shared_buffers - default is way too low (no formula)
     
  • max_fsm_relations
     
  • max_fsm_pages
     
  • effective_cache_size
     
  • vacuum_mem
     
  • WAL tuning
  
  
• Watch the logs closely for clues
   
• See Section 3.4.2 of the Admin guide for more information
   
• Again, the performance list

Previous: OS Tuning         [Table of Contents]         Next: Application Tuning