Am 24.08.2016 um 08:50 schrieb Marco Hoppstädter: > >> Hi Marco, >> >> ~300 MB for postgresql ? I hope you're just joking with us :-) >> >> To be short allow 1/4 of ram to postgresql to get it running better >> Use help from http://pgtune.leopard.in.ua/ >> >> a quick check give these configuration >> >> >> max_connections = 32 >> shared_buffers = 3584MB >> effective_cache_size = 10752MB >> work_mem = 224MB >> maintenance_work_mem = 1792MB >> checkpoint_segments = 128 >> checkpoint_completion_target = 0.9 >> wal_buffers = 16MB >> default_statistics_target = 500 >> >> etc, there's plenty of documentation or professional consulting on the web >> to help you to setup postgresql correctly. >> >> ;-) >> > > Hi Bruno, > > thanks for the helpful link. I've searched (and found) some information > about tuning PostgreSQL yesterday and already tried some modifications > on the config, but not that successful. Now I will try your suggestion. > Thanks. > > Best regards > Marco > Hi, now I've played around on http://pgtune.leopard.in.ua/ and configured these settings: max_connections = 32 shared_buffers = 3584MB effective_cache_size = 10752MB work_mem = 224MB maintenance_work_mem = 1792MB checkpoint_completion_target = 0.9 maintenance_work_mem = 896MB min_wal_size = 1GB max_wal_size = 2GB wal_buffers = 16MB default_statistics_target = 100 I started the file selection in the restore section of Bareos bat and it's running now for about half an hour. In top postgres is not using that much memory as before (see screenshot). So one question I have is about the max connections. Only bareos uses the postgres database, so would it be better to set max connections to a low value and therefore a higher work_mem value or the other way around? Thanks. Marco -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
smime.p7s
Description: S/MIME Cryptographic Signature
