Re: [GENERAL] Postgresql 9.6 and Big Data

2016-12-02 Thread John R Pierce
On 12/2/2016 12:19 AM, Job wrote: We need to archive this data to generate report and analysis views. on top of what Stephen said, I'd do as much preprocessing, and preaggregation as possible to simplify and speed up those report/analysis views for instance, storing min/max/mean

Re: [GENERAL] Postgresql 9.6 and Big Data

2016-12-02 Thread Stephen Frost
Job, * Job (j...@colliniconsulting.it) wrote: > we are planning to store historically data into a Postgresql 9.6 table. The question is less about what you're storing in PG and more about what you're going to be doing with that data. > We see on Postgresql limit that it could handle "big data".

[GENERAL] Postgresql 9.6 and Big Data

2016-12-02 Thread Job
Hello, we are planning to store historically data into a Postgresql 9.6 table. We see on Postgresql limit that it could handle "big data". In fact, limit for a single table is 32 Tb. We need to archive this data to generate report and analysis views. Anyone has experienced Postgresql 9.6 with