Upcoming presentations
No upcoming presentations...
Past presentations
Always-On with Postgres BDR (Deploying with Multi-Master)
The next generation of high availability.
This course will present the Postgres-BDR Always-On architecture. It will do an in depth review of logical replication and high availability concepts.
How to achieve maximum availability through a Postgres Multi-Master architecture will presented. Specific topics that will be covered:
1) How to achieve zero down time upgrades. 2) How to quickly (under a second) failover. 3) How to failo...
MVCC and Tuple Freezing through Pictures.
If you have an update or insert intensive application, please join us.
Teams that deploy an insert or update intensive application with Postgres need to understand the topic of tuple freezing. In proper planning this important aspect of the Postgres MVCC architecture, can result in prolonged performance spike or an outage. Unfortunately, may people struggle with the concept of tuple freezing. Hence, DBAs and Developers become confused about how to design applica...
Proper Vacuum operations is an important function of any Postgres deployment. Vacuum is at the core of many Postgres operational items. Having a Postgres deployment properly tuned for vacuum is critical for all successful Postgres production instances.
Unfortunately, may people struggle with the concepts behind vacuum and auto-vacuum. Hence, DBAs and Developers become extremely confused abou...
Logical Replication and pgLogical
use cases from Near real time upgrades to Change Data Capture
2ndQuadrant the contributors of logical encoding and logical replication to Postgres, has developed an open source extension called pglogical. This talk will cover the evolution of logical replication through out the history of Postgres and it will also cover the primary use cases of logical replication such as near real time upgrades and change data capture. It will then dive into specific f...
This is a keynote presentation as part of 2ndQuadrant's sponsorship. This presentation will cover the new and exciting features in PG11. Specific topics will be stored procedures, new Partitioning enhancements and JIT compilation. There will also be a quick look at some of the smaller features.
Postgres -- Past, Present and Future
What challenges most Postgres face in the next 5 years.
This talk will give a short history of Postgres, speaking about its origins and it's original goals. It will then discuss the reasons for the rapid growth in adoption and development it has seen over the years. Finally, it will then discuss the opportunities and challenges that Postgres faces in the next 3-5 years. Sources and illustrations from this talk, will be based on interviews from activ...
Internet of Things with PostgreSQL - Performance & Security
An in depth look at Postgres together IOT
Gartner predicts that there will be over 21 billion connected devices in the world by 2020 [https://www.gartner.com/doc/3299317]. More than anything else, this number drives all 3 Vs of Big Data: Velocity, Volume, Variety. The Internet of Things (IoT) causes some challenges for any database system: security, resource consumption, ingestion rate, replication as well as coping with various acces...