Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Indexes

Code Block
create index title_lower_idx on content (lower(title));
create spacekey_lower_idx on content (lower(spacekey));

Also see - http://confluence.atlassian.com/display/DOC/Database+Indexing+for+Improved+Performance

PostgreSQL

For /var/lib/pgsql/data/postgresql.conf

Code Block
effective_cache_size = 75000    
shared_buffers = 25000   
max_fsm_pages = 34000
max_fsm_relations = 2000
log_min_duration_statement 1000

Kernel Shared Memory

For /etc/sysctl.conf

Code Block
kernel.shmall = 313270528
kernel.shmmax = 313270528

To apply these settings

Code Block
sysctl -p