Search Postgresql Archives

Server Configuration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I am currently trying to tweak Postgresql 8.1, to improve the overall performance of the database.  I have read over the following page/artical http://www.powerpostgresql.com/PerfList/, however at the moment (not for much longer hopefully) my hands aree tied when it comes to altering the kernel parameters, and thus allocating more shared buffers.

I have read over the rest of the artical and adjusted some of the other values mentioned.  The values I have altered are:

work_mem = 33554                            # min 64, size in KB
maintenance_work_mem = 33554        # min 1024, size in KB
max_fsm_pages = 100000                  # min max_fsm_relations*16, 6 bytes each

vacuum_cost_delay = 50                   # 0-1000 milliseconds

wal_buffers = 64                               # min 4, 8KB each
commit_delay = 0                            # range 0-100000, in microseconds
commit_siblings = 50                       # range 1-1000

effective_cache_size = 33333000     # typically 8KB each

autovacuum = on                            # enable autovacuum subprocess?
autovacuum_naptime = 30               # time between autovacuum runs, in secs
autovacuum_vacuum_threshold = 400    # min # of tuple updates before vacuum
autovacuum_analyze_threshold = 100    # min # of tuple updates before analyze
autovacuum_vacuum_scale_factor = 0.4    # fraction of rel size before vacuum
autovacuum_analyze_scale_factor = 0.2    # fraction of rel size before analyze

Is it ok to have these settings with increasing the amount of shared buffers ?


Thanks for any advice,

Andy



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux