How big is too big? Content DB over 300 GB

Is there a way to optimize the content Database? It's taking up 322 GB!! I can't imagine why it would be so huge. Is postgreSql usually insanely huge?

I've been wondering why everything loads so slowly. I suspect this is the reason.

Comments

  • NorthOf45NorthOf45 Posts: 5,486

    My cms folder and everything under it is less than 10 GB, and I got a lot of stuff, including custom categories for everything. Try "Content Database Maintenance" -> "Condense Database"

  • Where is Content Database Management?

  • Found it. In the context menu of the Content Library panel.

  • I think I need to do this.  However, I am still not finding where to do this. Can you please post a screen shot? Thanks in advance :)

     

  • SofaCitizenSofaCitizen Posts: 1,889
    edited November 14

    Here you go

        

    1.png
    700 x 514 - 261K
    2.png
    552 x 364 - 140K
    Post edited by SofaCitizen on
  • Thank you!!

     

  • crosswindcrosswind Posts: 6,966
    edited November 15

    The size of cms cluster folder shouldn't affect the loading speed of Daz assets. Besides, 322 GB sounds pretty odd to me... OP you usually from time to time install / uninstall products as well as re-import metadata in high frequency, with multiple locations of Daz Libraries ?

    The size of my cluster folder never exceeds 10 GB since I used DS from 2018... though I have 27K installed products in Smart Content.

    Post edited by crosswind on
Sign In or Register to comment.