Re: PostgreSQL Volume Question

Поиск
Список
Период
Сортировка
От Ron
Тема Re: PostgreSQL Volume Question
Дата
Msg-id 5d37a105-501f-5718-0e70-9a64978d5547@gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Volume Question  (Data Ace <dataace9@gmail.com>)
Ответы using pg_basebackup for point in time recovery
Список 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.  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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: What to do when dynamic shared memory control segment is corrupt
Следующее
От: Pierre Timmermans
Дата:
Сообщение: using pg_basebackup for point in time recovery