Heroku Postgres: architecture of a cloud database service
In addition to providing a general purpose web platform, Heroku has a large, supporting Postgres service. Over the years, we've learned a lot about running Postgres at scale.
In this talk, we'll cover:
- why Postgres is attractive to run as a cloud service
- how to provision, manage, and monitor a Postgres fleet
- tradeoffs needed to make Postgres work in this environment
- automating failure recovery
- and more
Слайды
Видео
Другие доклады
-
Jean-Paul Argudo DaliboMigration to PostgreSQL : reasons... and consequences
The talk will be articulated around all the traditional arguments to "how chose PostgreSQL over other choices in the database domain"... But also, and that's quite new in the comunity, what are the consequences of this choice. Because the PostgreSQL adoption brings adoption of other things like Linux, but also, Open Source thinking, the fast pace of PostgreSQL will command new methods of validation the company must adapt to... etc.
-
45 мин
Никита Волков Sannsyn ASProgramming Postgres clients declaratively in Haskell with Hasql
This talk will cover "hasql", a highly-efficient library for integration of Haskell and PostgreSQL. The library provides an API for declarative programming, which is also quite flexible and terse. The talk will cover the benefits of declarative programming as well as the architectural and technical solutions behind the library, including the implementation of the PostgreSQL binary protocol. Hasql is used in PostgREST, a popular modern restful API for Postgres.
-
45 мин
Anastasia Lubennikova Postgres ProfessionalNew B-tree features
B-tree is the most widely used index type in PostgreSQL. This data structure and concerned algorithms are developed about forty years ago. But there is still an area for optimisations. In this presentation I'm going to talk about B-tree data structure, and its features important for the optimal index usage. Furthermore, I'll present a couple of new features which are expected to be included in PostgreSQL 9.6 release.
