Changes between Version 11 and Version 12 of Performance


Ignore:
Timestamp:
Aug 7, 2013, 9:18:27 AM (11 years ago)
Author:
damiano
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • Performance

    v11 v12  
    3636 * ''maintenance_work_mem'' - total RAM / 16
    3737 * ''synchronous_commit'' - set to ''off'' when doing bulk ingestion
    38  * ''wal_buffer'' - should be 16 MB; by default 1/32 from the shared buffer value is taken as long as it is lower then 16 MB otherwise it is 16 MB
     38 * ''wal_buffers'' - should be 16 MB; by default 1/32 from the shared buffer value is taken as long as it is lower then 16 MB otherwise it is 16 MB
    3939 * ''checkpoint_segments'' - 256 is a good start value when doing bulk ingestion
    4040 * ''checkpoint_completion_target'' - 0.0 (especially important for bulk ingestion)
    4141 * ''random_page_cost'' - 2.0 for spinning disk and 1.01 for ssd, high caching raid and when DB fits into RAM
    42  * ''effective_cache_write'' - total RAM - shared_buffers value
     42 * ''effective_cache_size'' - total RAM - shared_buffers value
    4343 * ''logging_collector'' - set to on if it isn't set already
    4444 * ''log_line_prefix'' - set to '%t ' to get timestamps in the logs