Bonjour,

J'ai un serveur Quad Xeon, avec 8 Go de ram,

Une base de donnée postgresql qui fait 10 Go.

J'ai des requetes sur des tables qui sont beaucoup updaté et qui prenne beaucoup de temps (0.3300 ms).

Je pense que j'ai un souci sur l'optimisation des paramétres de la base de donnée

voici mes params :


max_connections = 256
shared_buffers = 1500                   # min 16 or max_connections*2, 8KB each
temp_buffers = 500                      # min 100, 8KB each
max_prepared_transactions = 100

work_mem = 22000                        # min 64, size in KB
maintenance_work_mem = 500000           # min 1024, size in KB
max_stack_depth = 8192


max_fsm_pages = 100000                  # min max_fsm_relations*16, 6 bytes each
max_fsm_relations = 5000 


vacuum_cost_delay = 50                  # 0-1000 milliseconds
vacuum_cost_page_hit = 1000             # 0-10000 credits
vacuum_cost_page_miss = 1000            # 0-10000 credits
vacuum_cost_page_dirty = 120            # 0-10000 credits
vacuum_cost_limit = 2000                # 0-10000 credits

# - Background writer -

bgwriter_delay = 50                     # 10-10000 milliseconds between rounds
bgwriter_lru_percent = 1.0              # 0-100% of LRU buffers scanned/round
bgwriter_lru_maxpages = 25              # 0-1000 buffers max written/round
bgwriter_all_percent = 0.333            # 0-100% of all buffers scanned/round
bgwriter_all_maxpages = 50              # 0-1000 buffers max written/round

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

# - Checkpoints -

checkpoint_segments = 50                # in logfile segments, min 1, 16MB each
checkpoint_timeout = 1800               # range 30-3600, in seconds
checkpoint_warning = 180   

effective_cache_size = 2048             # typically 8KB each
random_page_cost = 3  


mémoire partagé
echo /proc/sys/kernel/shmmax = 256000000

POurriez vous me donner des conseils pour l'optimisation car la je rame.

Merci

David