Dmitry Cremer
Dmitry Cremer МИА "Россия Сегодня"
11:00 17 March
22 мин

Building PostgreSQL from sources for system administrators

  • why we build PostgreSQL from sources?
  • choice build options
  • dependencies
  • creation system environment
  • how to customise Linux for work with PostgreSQL
  • extra soft for PostgreSQL DBA



Другие доклады

  • Teodor Sigaev
    Teodor Sigaev Postgres Professional
    Arthur Zakirov
    Arthur Zakirov Postgres Professional
    90 мин

    Full text search capabilities in PostgreSQL

    Full text search in PostgreSQL is probably the most advanced one among relational DBMS. This tutorial will explain how to setup full text search configurations and dictionaries and how to build a ful text search system using an example of a simple popular science web site, with demonstration of various ranking functions. Also I will tell about new RUM index, which allows to accelerate execution of some kinds of full text queries and implements a new improved ranking function.

  • Dmitry Beloborodov
    Dmitry Beloborodov UIS, CoMagic
    45 мин

    Using PostgreSQL in UIS, CoMagic Projects

    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.


  • Aleksei Plotnikov
    Aleksei Plotnikov Skype
    45 мин

    Database platform architecture and administrating PostgreSQL in Skype

    Most of the main Skype services use a database platform based on PostgreSQL and other open-source technologies, such as Skytools, plProxy, pgBouncer, etc. This platform consists of several hundreds of servers with thousands of databases, which process hundreds of thousands of transactions per second. At the same time, the platform architecture allows its users (applications and their developers) to work with "logical" databases, without any worries about their real “physical” structure.

    Our Skype Database Platform team is responsible for the database platform infrastructure. We develop automation systems for various processes that help us ensure service reliability and facilitate development, testing, and deployment of code. In this presentation, I will outline the database platform architecture, review its main components, and tell you about the methods we use in our every-day work to ensure high availability, scalability, replication, fault tolerance, and more.

  • Ivan Panchenko
    Ivan Panchenko Postgres Professional
    22 мин

    Two Years of Professional Postgres

    A summary of what the Postgres Professional company has achieved in its two-year history:

    • Our achievements in PostgreSQL development.
    • What is the Russian Postgres Pro DBMS, and how is it related to PostgreSQL?
    • What is Postgres Pro Enterprise, and why Enterprise?
    • What about trainings and certification?