Program for PGConf India, 2019
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 TrainingPostgres 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 TrainingStreaming 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 TrainingPostgres-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 TrainingBuild 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 TrainingPGPOOL & 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 TrainingPostgreSQL: 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 KeynotesPostgreSQL: 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 KeynotesUnderstanding 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 AdministrationMigrating 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...
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 DeveloperComplex 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 DeveloperPostgreSQL : 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 DeveloperDeep 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 AdministrationDatabase 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 StudyMassively 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 AdministrationThe 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 DeveloperDivide 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...
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 AdministrationRestore 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 AdministrationMarketing Talks
Marketing Talks
presented by PGConf Organizers from PGConf India
Marketing Talks.
16:15 - 16:45 Ballroom OtherPanel Discussion/Lightning Talks
Panel Discussion/Lightning Talks
presented by PGConf Organizers from PGConf India
Panel Discussion/Lightning Talk
16:45 - 17:30 Ballroom OtherConference Dinner (In association with AWS)
presented by PGConf Organizers from PGConf India
Main Conference Dinner
19:00 - 22:00 Pool Side Lawn OtherWhat 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 KeynotesUpdate 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 KeynotesPartitioning & 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 AdministrationDetailed 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...
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 DeveloperRobust 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 DeveloperEXPLAIN: 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 AdministrationPostgresql 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 AdministrationBuilding 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 DeveloperVarious 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 AdministrationUnderstanding 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 DeveloperPostgreSQL 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 DeveloperHigh 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...
REPLACEMENT Please note that this talk replaces Timescale @ Zoomcar IOT stack
zHeap: a new storage formatzHeap: 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