![Anton Doroshkevich Anton Doroshkevich](/media//2017/01/24/doroshkevich.jpg.180x180.jpg)
PostgreSQL – a real alternative for high-load 1C-based systems
- 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.
Слайды
20170316H3_Doroshkevich.pptxДругие доклады
-
Radoslav Glinsky Skype (Microsoft)
Test environment on demand
Do you test your PostgreSQL releases prior to Production in a dedicated test environment? Are you sure that your test environment (shortly Test) is equal to Production and in an appropriate state?
In Skype we were facing multiple challenges associated with database testing:
- Simplifying complex Production architecture of thousands of PostgreSQL instances, interconnected with RPCs and replications, infrastructure servers and external DB scripts, into their Test counterparts.
- Constantly growing hardware requirements, insufficient cleanup of data generated in Test.
- Differences between Test and Production were appearing and accumulating. Recognizing and fixing them required lots of effort.
-
Andreas Scherbaum Pivotal
Introduction to Greenplum MPP Database
Overview of the architecture of Greenplum MPP (Massively Parallel Processing) database. Explain the internals of GPDB. Show how to configure and setup GPDB. How to distribute data effectively for MPP
VIDEO
-
Ivan Frolkov Postgres Professional
Relocatable tables in PostgresPro
With big data threads, even the upload of data to a database can often be problematic – apart from the data upload itself, you need to create indexes, perform VACUUM after the upload for correct Index-only scans, etc. From this talk, you will learn how to avoid most of such problems (if not all of them).
VIDEO
-
Maksim Viharev Alytics
Using PostgreSQL in automating contextual advertising by Alytics for near real-time processing of mixed OLTP/OLAP load
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