From: | Sebastien Douche <sdouche(at)gmail(dot)com> |
---|---|
To: | "pgsql-fr-generale(at)postgresql(dot)org" <pgsql-fr-generale(at)postgresql(dot)org> |
Subject: | Différence entre PG 8.4 et 9.3 sur la configuration |
Date: | 2013-09-09 16:42:16 |
Message-ID: | CAAGHeXHWM7VRh__9f1mxh5FjYP=sJeDxXeFKez=hr=vo8mNytw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-fr-generale |
Hello les amateurs d'éléphants !
Je cherche à vérifier les performances de PG 9.3 par rapport à notre
actuel 8.4 (intégration de CSV identiques, requêtes identiques, etc).
Pareil pour la conf. Mais les perfs en 9,3beta1 ne sont pas trés
bonnes. On suspecte la conf ou la VM.
Savez vous si la conf à changer pour la 9 sur la gestion des perfs ?
Si oui, avez vous des pointeurs intéressants ?
Merci d'avance.
Voici cette conf :
## Basic
fsync = on
autovacuum = off
synchronous_commit = off
lc_messages = 'C'
lc_monetary = 'C'
lc_numeric = 'C'
lc_time = 'C'
data_directory = '/srv/postgresql/9.3/main'
hba_file = '/opt/conf/postgresql/9.3/main/pg_hba.conf'
ident_file = '/opt/conf/postgresql/9.3/main/pg_ident.conf'
external_pid_file = '/var/run/postgresql/9.3-main.pid'
unix_socket_directories = '/var/run/postgresql/'
## Advance
shared_buffers = {{20|percent_of_ram}}MB
effective_cache_size = {{60|percent_of_ram}}MB
wal_buffers = {{0.1|percent_of_ram}}kB
temp_buffers = {{0.5|percent_of_ram}}MB
work_mem = {{4|percent_of_ram}MB
maintenance_work_mem = {{not_below(8, to_M(percent_of_ram(0.25)))}}MB
wal_writer_delay = 2000ms
max_stack_depth = 6MB
max_connections = 64
max_prepared_transactions = 0
max_locks_per_transaction = 2048
checkpoint_segments = 64
checkpoint_timeout = 3600
default_statistics_target = 300
## Advance (exemple avec 8Go de RAM)
shared_buffers = 1601MB
effective_cache_size = 4803MB
wal_buffers = 8005kB
temp_buffers = 40MB
work_mem = 320MB
maintenance_work_mem = 20MB
wal_writer_delay = 2000ms
max_stack_depth = 6MB
max_connections = 64
max_prepared_transactions = 0
max_locks_per_transaction = 2048
checkpoint_segments = 64
checkpoint_timeout = 3600
default_statistics_target = 300
## Profiling
logging_collector = on
log_min_duration_statement = 0
log_line_prefix = '%t [%p]: [%l-1] '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
log_directory = '/var/log/postgresql'
log_filename = 'postgresql-9.3-main-full.log'
log_truncate_on_rotation = off
--
Sebastien Douche <sdouche(at)gmail(dot)com>
Twitter: @sdouche / G+: +sdouche
From | Date | Subject | |
---|---|---|---|
Next Message | Stéphane Schildknecht | 2013-09-09 20:15:22 | Re: Différence entre PG 8.4 et 9.3 sur la configuration |
Previous Message | Stéphane Schildknecht | 2013-09-09 13:44:12 | Sortie de PostgreSQL 9.3 |