Postrelease
Talks
Talks archive
-
Anton Doroshkevich InfoSoft- Why is it time to consider switching to PostgreSQL?
- 1С and PostgreSQL interoperability.
- Why should we start with Windows?
- The first experience of migrating big enough 1С databases to Postgres.
- Large-scale projects on high-load systems, in figures.
-
Vadim Yatsenko Progress SoftThe 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.
-
Alexander Alekseev PostgresProZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS.
VIDEO
-
Roland Sonnenschein Hesotech GmbHOften 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.
Photos
Photo archive