> 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 -- 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.
