Опыт использования PostgreSQL в проектах UIS, CoMagic
Using PostgreSQL since 2003, we went all the way from a database of a couple of GB to a cluster of more than 5TB. At the moment, we have more than 700 tables and about 1500 stored procedures. We are ready to share with you the following: - Problems encountered at different development stages and how we resolved them. - Best practices in database administration. - Our own extension to work with several closely related databases. - Best known methods and tools that enable our several teams to work together without interference. - How we set up test equipment of different types. And, of course, we'll talk about optimization, and how we identify bottlenecks and high-load use cases.
VIDEO
Слайды
Другие доклады
-
180 мин
Alvaro Hernandez 8KdataPostgreSQL и Java: мастер-класс
Java is one of the most used languages when programming with PostgreSQL databases. Join this tutorial to learn or review the techniques to connect to postgres, best programming practices with JDBC, and to explore jOOQ, a mapper software that allows you to use the full power of SQL and postgres advanced query features while avoiding all the boilerplate code.
This tutorial is very practical: most of the time will be dedicated to iterate through code samples. It will cover:
- Introduction to Java and PostgreSQL
- Ways of connecting to PostgreSQL from Java (not only JDBC!)
- Introduction to JDBC. JDBC types. PostgreSQL JDBC
- Code demo: JDBC with PostgreSQL. From Java 1.4 to Java 8, best practices and code samples
- Code demo: jOOQ, a great mapper for PostgreSQL
- Java inside PostgreSQL
- The future of Java and PostgreSQL
About two-thirds of the tutorial will be dedicated to iterate over code samples and demos. All the code would be available from public open-source repositories and built with maven, so that any attendee may download it and build easily to play with it during the tutorial (although not required).
VIDEO
Part 1
Part 2
Part 3
Part 4
-
45 мин
Maksim Viharev AlyticsИспользование PostgreSQL в сервисе автоматизации контекстной рекламы Alytics для near-realtime обработки смешанной нагрузки OLTP + OLAP
In the data persistence layer, using PostgreSQL from the very start of development, we went all the way from a small cluster on a virtual machine to a multi-host system that provides near real-time processing of mixed OLTP/OLAP load. In this talk, I’m going to tell you about the main development stages of our analytical solution at the application and infrastructure levels, and describe the specifics of using PG that we encountered.
VIDEO
-
22 мин
Dmitry Grebenshchikov Диасофт Платформа -
45 мин
Andrey Fefelov Mastery.proPostgres как основа BI платформы, особенности, практический опыт
I will tell you about why Postgres is first-choice product as a foundation for your BI system with classical OLAP workload. Briefly it will be said about existing open source BI solutions.
I will also describe specific of our architecture, why we chose snowflake scheme and how we are doing extract, transformation and load procedures. It will be mentioned about special Postgres tuning for OLAP and massive data bulkload workloads. Also I will let you know about Postgres usage as a column database with cstore_fdw by Citus and results achieved. Cons and problems of our approach will be described in the end of the talk.
VIDEO