Program for PGConf India, 2019

2019-02-13
09:00
Jignesh Shah

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

presented by Jignesh Shah from AWS

Note: Training slides not shared by AWS.

Reduced downtime migration to RDS & Aurora PostgreSQL.

09:00 - 12:30 Ballroom 1 Training
Nidhi Bhammar

Postgres Performance Tuning and Optimization
Postgres Performance Tuning and Optimization

presented by Nidhi Bhammar from EnterpriseDB

Note: Training slides not shared by EDB.

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 Consider...

more

09:00 - 12:30 Ballroom 3 Training
Mohamed Tanveer

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

presented by Mohamed Tanveer from Zeta India

Note: Training slides not shared by 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.

09:00 - 12:30 Ballroom 4 Training
14:00
Nikhil Sontakke

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

presented by Nikhil Sontakke from Microsoft

Note: Training slides not shared by 2ndQuadrant.

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...

more

14:00 - 17:30 Ballroom 1 Training
Ranga GK

Build an intelligent and secure app with Azure managed services for PostgreSQL
Build an intelligent and secure app with Azure managed services for PostgreSQL

presented by Ranga GK from Microsoft

Note: Training slides not shared by Microsoft.

Get a deep dive into the new Azure Database for PostgreSQL. Learn how you can leverage these new choices of managed database services to build scalable, secure and enterprise-ready intelligent apps. Using insights from real world customer experiences and demos, we will walk through the service management capabilities, best practices to move ...

more

14:00 - 17:30 Ballroom 3 Training
Vijay Bhat

PGPOOL & PGBOUNCER : Failover Management & Connection Pooling
PGPOOL & PGBOUNCER : Failover Management & Connection Pooling

presented by Vijay Bhat from Taashee

Note: Training slides not shared by Taashee.

The training will discuss two products: PGPool and PGBouncer

High Availability can be achieved by configuring these products appropriately. Alongside, they also help in connection pooling.

14:00 - 17:30 Ballroom 4 Training
2019-02-14
09:00
Jim Mlodgenski

PostgreSQL: Your migration destination
PostgreSQL: Your migration destination

presented by Jim Mlodgenski from Amazon Web Services

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

09:00 - 09:45 Ballroom Keynotes
10:00
Simon Riggs

PostgreSQL: The Hyperconverged DBMS

presented by Simon Riggs from EDB

Download slides

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.

10:00 - 10:45 Ballroom Keynotes
11:15
Madan Kumar K

Understanding High Availability options for PostgreSQL

presented by Madan Kumar K from ScaleGrid

Download slides

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 ...

more

11:15 - 12:00 Ballroom 1 Database Administration
Prashant Agarwal

Migrating from Oracle to Enterprise-Ready Postgres in the Cloud
Migrating from Oracle to Enterprise-Ready Postgres in the Cloud

presented by Prashant Agarwal from EnterpriseDB

Download slides

Learn how you can break free from on-premises Oracle and quickly migrate to Postgres in the cloud. The session will cover step by step instructions for executing a migration from Oracle to Postgres:

  • Why migrate, challenges for database migra...
more

11:15 - 12:00 Ballroom 4 Application Developer
Nikhil Sontakke

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

presented by Nikhil Sontakke from Microsoft

Download slides

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...

more

11:15 - 12:00 Ballroom 3 Database Engine Developer
12:00
Dr.B.Hemalatha

Complex Database Queries with PostgreSQL

presented by Dr.B.Hemalatha from Indian Institute of Technology Kharagpur, India

Download slides

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 dat...

more

12:00 - 12:45 Ballroom 4 Application Developer
Beena Emerson

PostgreSQL : Decoding Partition

presented by Beena Emerson from EnterpriseDB

Download slides

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 routin...

more

12:00 - 12:45 Ballroom 3 Database Engine Developer
Jignesh Shah

Deep Dive into the RDS PostgreSQL Universe

presented by Jignesh Shah from AWS

Download slides

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 an...

more

12:00 - 12:45 Ballroom 1 Database Administration
14:00
Mani Subramanian

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

presented by Mani Subramanian from Groupon

Download slides

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 ...

more

14:00 - 14:45 Ballroom 4 Case Study
Goutam Tadi

Massively Parallel Postgres Database on Kubernetes
Managing Greenplum in Kubernetes environments

presented by Goutam Tadi from Pivotal

Download slides

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 monit...

more

14:00 - 14:45 Ballroom 1 Database Administration
Robert Haas

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

presented by Robert Haas from EnterpriseDB

Download slides

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 ...

more

14:00 - 14:45 Ballroom 3 Database Engine Developer
14:45
Jobin Augustine

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

presented by Jobin Augustine from Percona

Download slides

  • 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...
more

14:45 - 15:30 Ballroom 4 Database Engine Developer
Amul Sul

Knowing your data cluster and startup processes

presented by Amul Sul from EnterpriseDB

Download slides

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 tal...

more

14:45 - 15:30 Ballroom 3 Database Administration
Abhijit Menon-Sen

Restore your backups!

presented by Abhijit Menon-Sen from 2ndQuadrant

Download slides

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 backu...

more

14:45 - 15:30 Ballroom 1 Database Administration
16:15
PGConf Organizers

Marketing Talks
Marketing Talks

presented by PGConf Organizers from PGConf India

Marketing Talks.

16:15 - 16:45 Ballroom Other
16:45
PGConf Organizers

Panel Discussion/Lightning Talks
Panel Discussion/Lightning Talks

presented by PGConf Organizers from PGConf India

Panel Discussion/Lightning Talk

16:45 - 17:30 Ballroom Other
19:00
PGConf Organizers

Conference Dinner (In association with AWS)

presented by PGConf Organizers from PGConf India

Main Conference Dinner

19:00 - 22:00 Pool Side Lawn Other
2019-02-15
09:00
Robert Haas

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

presented by Robert Haas from EnterpriseDB

Download slides

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 ...

more

09:00 - 09:45 Ballroom Keynotes
10:00
Lakshmikant Gundavarapu (L.K)

Update on Microsoft’s learning and progress on supporting PostgreSQL as a fully managed service on Azure
Update on Microsoft’s learning and progress on supporting PostgreSQL as a fully managed service on Azure

presented by Lakshmikant Gundavarapu (L.K) from Microsoft

This an update on Microsoft’s learning and progress on supporting PostgreSQL as a fully managed service on Azure.

10:00 - 10:45 Ballroom Keynotes
11:15
Simon Riggs

Partitioning & Time Series

presented by Simon Riggs from EDB

Download slides

PostgreSQL Partitioning has been through many different versions. Declarative partitioning in PG10 has many enhancements and some very subtle performance effects and changes. This talk will discuss every aspect of partitioning for adminsitration and performance, with special focus on Time Series data an...

more

11:15 - 12:00 Ballroom 4 Database Administration
Avinash Vallarapu

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

presented by Avinash Vallarapu from Percona

Download slides

** 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 require...
more

11:15 - 12:00 Ballroom 1 Database Engine Developer
Dilip Kumar

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

presented by Dilip Kumar from EnterpriseDB

Download slides

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 intr...

more

11:15 - 12:00 Ballroom 3 Database Engine Developer
12:00
Pallavi Sontakke

Robust Replication strategies in PostgreSQL: Repmgr

presented by Pallavi Sontakke from 2ndQuadrant

Download slides

*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...

more

12:00 - 12:45 Ballroom 3 Application Developer
Jeevan Chalke

EXPLAIN: Understand the query plan

presented by Jeevan Chalke from EnterpriseDB

Download slides

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, ...

more

12:00 - 12:45 Ballroom 1 Database Administration
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 from Rebataur

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

12:00 - 12:45 Ballroom 4 Database Administration
14:00
Ranga GK

Building Micro services architecture for Azure database for PostgreSQL.
Building Micro services architecture for Azure database for PostgreSQL.

presented by Ranga GK from Microsoft

Ranga will speak about building Micro services architecture for Azure database for PostgreSQL.

14:00 - 14:45 Ballroom 1 Application 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 from CSG Systems

Download slides

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 ...

more

14:00 - 14:45 Ballroom 4 Database Administration
Alex Scotti

Understanding TOAST

presented by Alex Scotti from AWS

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.

14:00 - 14:45 Ballroom 3 Database Engine Developer
14:45
Pavan Deolasee

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

presented by Pavan Deolasee from EDB

Download slides

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 engin...

more

14:45 - 15:30 Ballroom 3 Database Engine 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 from Percona

Download slides

  • *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 ma...
more

14:45 - 15:30 Ballroom 1 Database Administration
Kuntal Ghosh

REPLACEMENT Please note that this talk replaces Timescale @ Zoomcar IOT stack

zHeap: a new storage format
zHeap: a new storage format

presented by Kuntal Ghosh from Amazon Web Services

Download slides

This talk will focus on zHeap which is a new storage format to avoid bloat due to PostgreSQL's MVCC mechanism while doing updates and deletes. When not handled efficiently, bloat is accumulated over time resulting in increase of table and index sizes although the amount of actual data remains unchanged and...

more

14:45 - 15:30 Ballroom 4 Database Engine Developer