Program for PGConf India, 2019

Unscheduled events
Madan Kumar K

Understanding High Availability options for PostgreSQL

presented by Madan Kumar K

Configuring High Availability is critical for any production PostgreSQL deployment. High availability goes beyond the setup of streaming replication. You need to understand the implications of process failures, node failures & network partitions on your cluster. In this talk we will present in detail three popular options to setup high availability using PostgreSQL built-in Streaming replicatio...

more

Database Administration
Pavan Deolasee

PostgreSQL Extensions: What exists and how to create a new one?

presented by Pavan Deolasee

In this talk, we shall look at PostgreSQL's core feature of adding desired functionality via new extensions. We shall look at some key built-in extensions such as pageinspect and pg_stat_statements and also see how to create a new extension to solve a specific problem.

The talk will be useful for database engine developers as well as DBAs as they would learn how to use extensions during crit...

more

Database Engine Developer
Mani Subramanian

Database Operations at Groupon using Ansible
Make DBA life easier by Automation

presented by Mani Subramanian

Most of the database operations can be automated using DevOps tool. At Groupon we have automated our database operations using Ansible Playbook that includes Database Provision, User creation, Whitelisting application servers(Grants), Setting up replication, Destroying/decommissioning instances, Failover databases with data center and failover to DR center. Interesting tools can be developed u...

more

Case Study
Jignesh Shah

Deep Dive into the RDS PostgreSQL Universe

presented by Jignesh Shah

In this session we will deep dive into the exciting features of Amazon RDS for PostgreSQL, including new versions of PostgreSQL releases, new extensions, larger instances. We will also show benchmarks of new RDS instance types, and their value proposition. We will also look at how high availability and read scaling works on RDS PostgreSQL. We will also explore lessons we have learned managing a...

more

Database Administration
Goutam Tadi

Massively Parallel Postgres Database on Kubernetes
Managing Greenplum in Kubernetes environments

presented by Goutam Tadi

Installing, Expanding and Upgrading a distributed database as its data grows: what are the challenges? Greenplum on Kubernetes promises to manage these challenges by leveraging Kubernetes concepts.

This presentation will demonstrate how database users can install, manage, expand and monitor their Greenplum clusters on Kubernetes for various purposes, within exploration, staging and productio...

more

Database Administration
Ibrar Ahmed

Joins Heterogeneous Databases using PostgreSQL Foreign Data Wrappers

presented by Ibrar Ahmed

PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database. The other database might be a relational database such as MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of Foreign Data Wrappers (FDW). This presentation will explain...

more

Database Administration
Pallavi Sontakke Amruta

Robust Replication strategies in PostgreSQL: Repmgr

presented by Pallavi Sontakke, Amruta

*Robust Replication strategies in PostgreSQL: Repmgr * In today's business environments High Availability of your Databases is very important. PostgreSQL offers physical replication for this; Discussion on how Repmgr uses it to solve these issues.

Repmgr is an open-source tool suite for managing replication and failover in a cluster of PostgreSQL servers. It enhances PostgreSQL's built-i...

more

Application Developer
Robert Haas

What Is The Future of PostgreSQL?
PostgreSQL is increasingly successful, but many challenges remain.

presented by Robert Haas

Over the last several years, PostgreSQL has added multiple ground-breaking capabilities, including parallel query, logical replication, declarative partitioning, and just-in-time compilation. In this talk, I'll discuss how I expect to see these capabilities evolve in future releases, as well as some trends that may drive new development and some new capabilities that PostgreSQL may gain as it a...

more

Keynotes
Priya Ranjan

Postgresql HA on Cloud using Kubernetes
How to leverage Kubernetes to provide High Availibility on the Cloud for Postgresql

presented by Priya Ranjan

Kubernetes has become the de-factor standard in Multi Cloud Container orchestration and HA environment. Postgresql has emerged as a leading choice of OpenSource database in all the Cloud Providers. Going forward "Postgresql HA using Kubernetes" should enable companies to scale Postgresql without being lockedin to any particular Cloud / Hardware provider. Kubernetes also offers a flexible plugga...

more

Database Administration
Amul Sul

Knowing your data cluster and startup processes

presented by Amul Sul

It is very important to know what you have at first place when you initialize a database cluster using initdb so that you can make necessary configuration before starting up the server. However, after server start you must know which are the auxiliary processes are forked by the Postgres and their use.

In this talk, which is divided into two parts, first, we will discuss the directory struct...

more

Database Administration
Robert Haas

The PostgreSQL Query Planner
Why does my query need a plan, anyway?

presented by Robert Haas

Sequential scan vs. index scan vs. bitmap index scan vs. index-only scan. Join strategies. Join reordering. Using EXPLAIN. Row count and cost estimation. Things the query planner doesn't understand. Things that are nearly always slow. What's new in query planning in recent PostgreSQL releases? Upcoming features and future work.

Database Engine Developer
Jeevan Chalke

EXPLAIN: Understand the query plan

presented by Jeevan Chalke

Many times we were amazed that why is my query running slow? And couldn't get to know exactly what's an issue. However, if we know the plan of a query, then life becomes easy. For that EXPLAIN is our handy tool which gives us a query-plan for the given statement. For good performance and tuning the system, choosing the right plan is very necessary. PostgreSQL planner is designed such a way...

more

Database Administration
Beena Emerson

PostgreSQL : Decoding Partition

presented by Beena Emerson

Trigger based methods for partitioning were replaced with native declarative partitioning in PostgreSQL 10 which enhanced the performance. V10 introduced the declarative partition, adding range and list partitions with support for sub partitioning. It has modified the internal tuple routing for partitioning. V11 added hash partitions, default partitions: a catch-all partition for tuples that d...

more

Database Engine Developer
Nikhil Sontakke

The state of the art in logical replication: PGLogical and BDR
PGLogical and BDR: Latest and Greatest

presented by Nikhil Sontakke

PostgreSQL has in-built logical replication features. The PGLogical and BDR extensions provide additional functionality built-on top. A lot of enhancements have gone on in into these solutions over the last few years. This talk will provide a summary of the latest and greatest in this area of logical replication that solve various customer/end-user requirements and needs.

Database Engine Developer
Abhijit Menon-Sen

Restore your backups!

presented by Abhijit Menon-Sen

How do Postgres backups work? What's really going on behind the friendly façade of Barman or pgBackRest or WAL-E? What's in this base backup, and how long is it going to take for your database to be up again?

This talk is an in-depth look at the mechanisms in Postgres to take backups, and how restoring from a backup actually works. Take a fresh look at checkpoints, consistency, point-in-time...

more

Database Administration
Jobin Augustine

Divide and Conquer data:- Advanced Methods for partitioning and sharding data - Latest developments

presented by Jobin Augustine

  • Historically PostgreSQL was not known for features available for horizontal scalability in handling large data sets. As a result, many PostgreSQL based systems were designed to handle specific types of business cases. But the PostgreSQL as its core was a bit lagging behind. Things started changing over a period of time. New methods and features like partitioning, sharding, FDWs started emergi...
more

Application Developer
Avinash Vallarapu

High availability and automatic failover in PostgreSQL on Kubernetes, On-premise and cloud using open source solutions.
PostgreSQL High Availability

presented by Avinash Vallarapu

  • *Title : High availability and automatic failover in PostgreSQL on Kubernetes, On-premise and cloud using open source solutions. *

  • Abstract :

    • PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements while maintaining a secondary focus on Oracle compatibility gave PostgreSQL a great market penetr...
more

Database Administration
Avinash Vallarapu

Detailed Understanding of MVCC and Autovacuum Internals in PostgreSQL
Usually mistaken PostgreSQL Internals

presented by Avinash Vallarapu

** Title : A detailed understanding of MVCC and autovacuum internals in PostgreSQL. **

  • *Abstract : *
    • PostgreSQL implements MVCC in a slightly different way when compared to databases like Oracle, MySQL and others. In PostgreSQL, you see a different method for managing UNDO which requires a cleanup concept called vacuum. Over a period of time, PostgreSQL implemented autovacuum that h...
more

Database Engine Developer
Premnath J

Various attacks and its possible solutions to secure data in PostgreSQL Database management system
Database Security in PostgreSQL

presented by Premnath J

Data security is an emerging concern which is attracting a lot of attention. Database Security is a composed part in which it protects and secures the sensitive data or database management software from some unauthorized user or from malicious attacks. A secure database is the one which is reciprocated from different possible database attacks. Database Security need can be judged by the increas...

more

Database Administration
Dr.B.Hemalatha

Complex Database Queries with PostgreSQL

presented by Dr.B.Hemalatha

AI and machine learning techniques are being increasingly used in data analytics as a tool for planning, prediction and identifying hidden patterns. Effective use of these tools needs a large volume of data that is presented in a multiplicity of ways . Often, such data needs to be extracted from database that have defined structures and a simple SQL query wouldn’t suffice. A straig...

more

Application Developer
Dilip Kumar

Parallel Query in PostgreSQL: How not to (mis)use it?

presented by Dilip Kumar

This is a joint talk with Rafia Sabih.

Since the release of v9.6 we have seen numerous articles and talks on the benefits of parallel query in PostgreSQL. Still, I could not help but notice the queries and discussions where it is either misused, or is over-expected to perform. In this talk we will discuss how to better utilise intra-query parallelism to enhance the query performance without ...

more

Database Engine Developer
Simon Riggs

PostgreSQL: The Hyperconverged DBMS

presented by Simon Riggs

PostgreSQL contains everything you need for managing application data. Review all of the different aspects of PostgreSQL data management, including GIS, full text, graph, document storage, time series and of course relational.

Keynotes
ajscotti@amazon.com

Understanding TOAST

presented by ajscotti@amazon.com

PostgreSQL has 8k pages but allows columns to be 1GB is size. Thanks to The Oversized-Attribute Storage Technique (TAOST), POstgreSQL allows you to store values larger than what fits on a single page. In this talk, you will learn how TOAST works, what a TOAST table is and what to watch out for when your data is TOASTed.

Database Engine Developer
Rahul Gupta

Using Timescale DB built over Postgres for Time Series Data in Zoomcar IOT stack

presented by Rahul Gupta

This talk will cover what Zoomcar does in IOT space, different business use cases and then will move on to the challenges we faced with the time series data that we were collecting from our IOT devices in our assets, car and cycles both. What different options we evaluated, at what different parameters we looked for and how we finally made our decision to choose Timescaledb. It will also cover ...

more

Case Study
Nikhil Sontakke

Postgres-BDR: Multi Master Replication
Postgres-BDR: Multi Master Replication

presented by Nikhil Sontakke

This training covers the basic concepts of Bi-Directional Replication for PostgreSQL. Postgres-BDR (BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status. This h-day training cover areas such as setting up geographically distributed clusters, using highly efficient asynchronous logical replication, and exploring deployment options for Postg...

more

Training
Jignesh Shah

Reduced downtime migration to RDS & Aurora PostgreSQL
Reduced downtime migration to RDS & Aurora PostgreSQL

presented by Jignesh Shah

Reduced downtime migration to RDS & Aurora PostgreSQL.

Training
Nidhi Bhammar

Postgres Performance Tuning and Optimization
Postgres Performance Tuning and Optimization

presented by Nidhi Bhammar

Gain the high value skills you need to be armed for epic change. Our Postgres Performance Optimization Training will teach you how to configure your database server and use available server resources efficiently without compromising performance. We’ll cover.

Postgres Performance Optimization, Server Parameter Tuning, Operating System Considerations, visibility to statistics and options for o...

more

Training
Mohamed Tanveer

Streaming and Logical Replication in Postgres 10
Streaming and Logical Replication in Postgres 10

presented by Mohamed Tanveer

This course covers the implementation of streaming(physical) and logical replication feature introduced in PostgreSQL 10 and their internals. Customizing parameter for different use cases. Approaches to set up cascaded and delayed replication. Troubleshooting replica lag and solving query conflicts.

Training
Jim Mlodgenski

PostgreSQL: Your migration destination
PostgreSQL: Your migration destination

presented by Jim Mlodgenski

Why after 30 years of active development is PostgreSQL the DBMS of the Year for the second year in a row? Why is every aspect of the PostgreSQL community from global conferences to local user groups growing at phenomenal rates? Our industry is going through a fundamental shift away from the commercial databases to open source and PostgreSQL is where most people are going. And it is not just the...

more

Keynotes