Why industrial manufacturing data need special considerations

(PG Day’16 Russia, St. Petersburg)

In respect to storage, retrieval, aggregation, and reporting of industrial manufacturing data, special considerations are needed. Data are immutable and written only once. Customers are normally interested in streams and aggregations, not in a single data record. Really “Big Data” may apply. In one of our projects, we had to store more than 3 million measurements every second into PostgreSQL. We developed a Terabyte database, that enables users to evaluate both live data and historical data within an acceptable period of time – not only within the company’s network, but also outside using tablet or smartphone. The requirements and technical aspects of our solutions are explained: How is the required performance achieved by using PostgreSQL array features and XML capabilities?

Here you can find the presentation.