Re: [Bacula-users] choosing database.

Subject:

From:

Mauro <mrsanna1 AT gmail DOT com>

To:

lst_hoe02 AT kwsoft DOT de

Date:

Thu, 19 Sep 2013 22:23:39 +0200

On 19 September 2013 21:53, <lst_hoe02 AT kwsoft DOT de> wrote:

Zitat von Konstantin Khomoutov <flatworm AT users.sourceforge DOT net>:

Our biggest single job has about 1TB data with some 3.3 million files.
This lead to around 1GB spooled attributes which will be absorbed in
less then 2 minutes. Database is Postgres with some minimal tuning:

shared_buffers = 128MB
temp_buffers = 32MB
work_mem = 32MB
maintenance_work_mem = 64MB
checkpoint_segments = 32
checkpoint_completion_target = 0.9

That's all

Database hovers around 21GB in size with with some 57 million rows in
the file table.

how much ram you have in your server?

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread]

Current Thread

[Next in Thread>

Previous by Date:

Re: [Bacula-users] choosing database., lst_hoe02

Next by Date:

Re: [Bacula-users] choosing database., Andrea Venturoli

Previous by Thread:

Re: [Bacula-users] choosing database., lst_hoe02

Next by Thread:

Re: [Bacula-users] choosing database., lst_hoe02

Indexes:

[Date] [Thread] [Top] [All Lists]