Re: PostgreSQL Volume Question

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 19 Jun 2018 06:37:52 -0500



    On 06/15/2018 11:26 AM, Data Ace wrote:

    
        Well I
            think my question is somewhat away from my intention cause
            of my poor understanding and questioning :( 
         
        Actually,
            I have 1TB data and have hardware spec enough to handle this
            amount of data, but the problem is that it needs too many
            join operations and the analysis process is going too slow
            right now.
         
        I've
            searched and found that graph model nicely fits for network
            data like social data in query performance.
      
    
    If your data is hierarchal, then storing it in a network database is
    perfectly reasonable.  I'm not sure, though, that there are many
    network databases for Linux.  Raima is the only one I can think of.

    
         Should
            I change my DB (I mean my DB for analysis)? or do I need
            some other solutions or any extension?
        

        Thanks

        
    -- 

      Angular momentum makes the world go 'round.