Оптимизация PostgreSQL для реальных промышленных систем
Often it is enforced by the customer or even by law, to document the circumstances of the production of parts or lots. This talk is about the automated generation and storage of the corresponding administrative data and their correlation to measurements. Administrative data are entities like suppliers batch, article, serial number or production date. They are often to be exchanged with ERP systems.
Слайды
Другие доклады
-
22 мин
Jean-Paul Argudo DalibotemBoard – новый инструмент для PostgreSQL
Dalibo team produces open source tools for PostgreSQL among other things for many years now (see http://dalibo.github.io/).
This time I'll present temBoard, a new tool to remotely control PostgreSQL databases. The project is visible at https://github.com/dalibo/temboard
It's about monitoring, supervision, remote settings and actions... and many more features to come. The main goal is to provide a comprehensive console for PostgreSQL. It's needed by production DBAs, to daily achieve their tasks. We heard Dalibo's customers, as many of them wrote the specs :-)
-
45 мин
Vadim Yatsenko ООО Прогресс СофтОчень большие таблицы в PostgreSQL. Или как превратить 60+ Tb в 10+ Tb
The talk will describe how we have implemented storage of large tables (+1 billion rows per day). The project exists in production 2 years. The total amount of data - 300 Tb (25 PostgreSQL servers * 2 Data Center). I'll tell about mistakes in organization of large tables storage in the initial phase of the project, and how these mistakes were corrected. I'll also talk about how to organize the data rotation and archiving. I voiced questions about what we were missing in PostgreSQL 9.4 out of what appeared in the 9.5 and 9.6. And also, what new features we are waiting for new releases of PostgreSQL.
-
45 мин
Dmitry Belyavskiy ТЦИКриптография в реляционных СУБД
Real-word data often need cryptographycal protection. The presentation describes typical problems that can be solved using cryptographycal methods and the right ways to use cryptography with RDBMS. The newest solutions suggested for usage with PostgreSQL are described.
VIDEO
-
22 мин
Sergey Mirvoda ООО Октоника, УрФУАналитика в сёла! Опыт внедрения BI системы, функционирующей на ограниченном или разделяемом железе
Experience we've got after 5 years of developing, deploying and improving BI system http://colibri365.ru used in government. I would talk about government IT reality and our way over it. Postgres performance improvements, using of latest features, overwriting of user generated queries to help query optimizer and other tweaks and hacks to tackle limited hardware problems. These lead us to number of computer science papers and (now committed) patches to Postgres (see Andrey Borodin talks for details).
VIDEO