On mardi, 23 août 2016 13.15:03 h CEST Marco Hoppstädter wrote: > Some additional info: > > Bareos is running in version 15.2.2-37.1 on Ubuntu 16.04.1. Server is a > quad core Xeon X3450 @ 2.67GHz, 14 GB RAM. System and database on > Hardware RAID1. > When bareos file selection is running > > - one core is at 100% (postgres: bareos bareos [local] INSERT) > - RAM is not fully used, no swap > - disk i/o is low > > See screenshot, if screenshots are possible. > > > Best regards. > > Am 23.08.2016 um 12:22 schrieb Marco Hoppstädter: > > Hello, > > > > I've asked this question before but got no response. I am trying to > > restore some files from a large backupjob (~ 600GB) with a lot of files > > (~ 4.7 million). When selecting the backup job in the WebUI the > > selection of the files seems to take forever (at least two hours or so). > > So is this normal behaviour? Or can anyone give me a clue how to speed > > this up? > > > > Thanks in advance for any help! > > 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. ;-) -- Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch Bareos Partner, openSUSE Member, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot openSUSE Tumbleweed (20160820) (x86_64) Linux 4.6.4-2-default x86_64 GNU/Linux, nvidia: 370.23 Qt: 5.6.1, KDE Frameworks: 5.24.0, Plasma: 5.7.3, kmail2 5.2.3 -- 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.
