| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL Volume Question |
| Date: | 2018-06-19 11:37:52 |
| Message-ID: | 5d37a105-501f-5718-0e70-9a64978d5547@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.\302\240 I'm not sure, though, that there are many network
databases for Linux.\302\240 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Timmermans | 2018-06-19 12:03:58 | using pg_basebackup for point in time recovery |
| Previous Message | Alban Hertroys | 2018-06-19 07:02:23 | Re: What to do when dynamic shared memory control segment is corrupt |