The Percona Live Open Source Database Conference 2017 has an excellent set of breakout sessions on PostgreSQL in our PostgreSQL track.
PostgreSQL is one of the most advanced enterprise-class open source databases, with features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions, and more.
Below are the talks covering PostgreSQL at this year’s conference.
2:20pm to 3:10pmRoom 203
Lukas Fittl (Citus Data), Ozgun Erdogan (Citus Data)If you’re building a SaaS application, you probably already have the notion of tenancy built in your data model. Typically, most information relates to tenants / customers / accounts and your database tables capture this natural relation. With smaller amounts of data, it’s easy to throw more hardware at the problem and scale up your database.PostgreSQL Tools and Techniques Sharding
3:50pm to 4:40pmRoom 203
Nikolay Samokhvalov (-)Traditionally, many mobile and web developers consider using stored procedures as a very old and obvious anti-pattern. But time goes on, Open Source (R)DBMSs become stronger, and it is a good moment to look at stored procedures and triggers at different angle.PostgreSQL Tools and Techniques Programming
4:50pm to 5:15pmRoom 203
Christophe Pettus (PostgreSQL Experts Inc.)Uber made waves in 2016 by publishing a paper describing their reasons for moving from PostgreSQL to MySQL. So, were they right? Mostly, no. We'll talk about the points they raise about PostgreSQL vs MySQL, and how they could have stayed on PostgreSQL while avoiding or mitigating the problems they faced... and honestly talk about how PostgreSQL can improve to meet their criticisms.PostgreSQL
- Business / Case Studies
5:15pm to 5:40pmRoom 203
Sean Chittenden (HashiCorp)PostgreSQL and ZFS were made for each other.PostgreSQL Data in the Cloud Replication
12:50pm to 1:40pmBallroom G
Ilya Kosmodemiansky (PostgreSQL-Consulting LLC)Input-output performance problems are on every day agenda for DBAs since the databases exist. Volume of data grows rapidly and you need to get your data fast from the disk and moreover - fast to the disk. For most databases there is a more or less easy to find checklist of recommended Linux settings to maximize IO throughput. In most cases that checklist is good enough.MySQL PostgreSQL Optimization