title

text

Алексей Лесовский
Алексей Лесовский PostgreSQL Consulting LLC
15:00 03 February
180 мин

Streaming replication in practice.

Слайды

Видео

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

  • Konstantin Evteev
    Konstantin Evteev X5 FoodTech
    45 мин
  • Fabio Telles Rodriguez
    Fabio Telles Rodriguez Timbira
    45 мин

    High Concurrency with Postgres: the Bank of Brazil in real life

    Challenges and solutions found in documents dematerialization and bank cheque processing system used in the Bank of Brazil.

  • Dmitry Vasiliev
    Dmitry Vasiliev Postgres Professional
    45 мин

    PostgreSQL Scalability

    The talk describes performance benchmarking results of PostgreSQL on modern Hi-End servers. The main attention was paid to the locks for shared data access and associated bottlenecks. The testing propose was to test the linear read scalability limits with an increase of cores number allocated for PostgreSQL. Testing was performed for different postgres versions (9.4, 9.5, 9.6) to check new features designed to increase performance on multiprocessing architectures.

  • Peter  van Hardenberg
    Peter van Hardenberg Heroku
    45 мин

    Megascale PostgreSQL-as-a-Service: Operating 10^6 Databases

    Heroku Postgres is a cloud database service and the largest provider of PostgreSQL as a service anywhere. We operate more than 1,000,000 PostgreSQL databases with a team of about 10 people. We may be the most efficient DBAs in history, with approximately 100,000 databases per person on our team! This talk will introduce the opportunity and challenges of building and operating a cloud database service, as well as discussing the strategies we use to build, operate, and scale this product and team for the last six years now. We will include details about * a brief introduction to the service to provide context * strategies to design and build such a data service * operational war stories like how to recover from losing thousands of servers at once, * common challenges users have with Postgres * and a basic overview of the technical architecture

    This is a complementary talk to Will Leinweber's talk, which will go into much more depth on the architecture of the software we have written.