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 |