Program for PGConf India, 2020

2020-02-26
09:00
Avinash Vallarapu Jobin Augustine

PostgreSQL Tutorial For Oracle And Mysql Dbas And Beginners
PostgreSQL Tutorial for Oracle DBAs and Beginners

presented by Avinash Vallarapu, Jobin Augustine from Percona

  • This tutorial is focused on teaching PostgreSQL to professionals who are already experienced with Oracle or MySQL or SQL Server. Relational databases share a lot of similar concepts. You may find it easier when the concepts of PostgreSQL are related with Oracle/MySQL. Thus, I would start with PostgreSQL Architecture for Oracle/MySQL DBAs.

  • As we discuss from basics, even a beginner could ...

more

09:00 - 12:30 Grand Victoria 1 Training
Krishnaswamy Subramanian Nithya Natarajan

The Kubernetes Spell for PostgreSQL on the Cloud
The Kubernetes Spell for PostgreSQL on the Cloud

presented by Krishnaswamy Subramanian, Nithya Natarajan from ThoughtWorks

Kubernetes lets you deploy applications in ways that are highly available and resilient, and can utilize the underlying resources more efficiently. This can bring huge cost savings to the business, especially when you’re entrusted with running PostgreSQL clusters on Kubernetes, rather than over traditional VMs.

In this training, we share our experiences of running and managing 100+ PostgreSQ...

more

09:00 - 12:30 Grand Victoria 2 Training
Hari Kiran

PostgreSQL Performance Optimization - A DBA's View
PostgreSQL Performance Optimization - A DBA's View

presented by Hari Kiran from 2ndQuadrant

Training focusses on a few Linux, PostgreSQL, and Application performance tips & techniques. All these are tested on low-mid-high read/write-intensive database shops. The takeaway from this Training would be an assessment of PG Instances from a Performance Optimization standpoint.

09:00 - 12:30 Robusta + Arabica Training
13:00
PGConf Organizers

26th Feb, Lunch

presented by PGConf Organizers from PGConf India

Lunch

13:00 - 14:00 Grand Victoria 1 Other
14:00
Parikshit Savjani Deepthi Anantaraman & Parikshit Savjani

Architecting operational real-time analytics apps with PostgreSQL & Hyperscale (Citus)
Architecting operational real-time analytics apps with PostgreSQL & Hyperscale (Citus)

presented by Parikshit Savjani, Deepthi Anantaraman & Parikshit Savjani from Microsoft

Data is exploding with billions of device connected and emitting petabytes scale of data every minute. Postgres is the world’s most advanced open source relational database with NoSQL capabilities built in—and is growing in usage globally, including for business-critical, real-time streaming and operational analytics applications. With Hyperscale (Citus) now available as a built-in deployment o...

more

14:00 - 17:30 Grand Victoria 2 Training
Jim Mlodgenski

Introduction to PL/pgSQL Development

presented by Jim Mlodgenski from Amazon Web Services

When developing against a PostgreSQL database, many times you will use SQL from your applications, but sometimes you need more. You might need to run some of your logic on the database server for performance or you may want to just create some server-side functions to simplify your application development. There is an infinite number of reasons why you would want to write some code that runs on...

more

14:00 - 17:30 Robusta + Arabica Training
Mansur Shaikh

PostGIS - A DBA and Developer view
PostGIS - A DBA and Developer view

presented by Mansur Shaikh from EnterpriseDB

PostGIS is an open-source, freely available spatial database extension for the PostgreSQL Database Management System. In a nutshell, PostGIS adds spatial functions such as distance, area, union, intersection, and specialty geometry data types to PostgreSQL. So in a normal database, you store data of different types (numeric, text, timestamps, images…) which can help you answer questions like ‘h...

more

14:00 - 17:30 Grand Victoria 1 Training
2020-02-27
09:00
Parikshit Savjani

Distributed PostgreSQL is a game changer
Distributed PostgreSQL is a game changer

presented by Parikshit Savjani from Microsoft

Postgres is one of the fastest growing DBMS in the industry in terms of popularity. Its extensible architecture combined with truly open source community development makes it very feature rich database engine with unprecedented speed of innovation. But as a developer or DBA, scaling your Postgres workload can be a complex daunting task. Microsoft loves Postgres and with its Azure Database for P...

more

09:00 - 09:45 Grand Victoria 1 Keynote
09:45
Gautam Khanna

Open Source, Data and Postgres – An Enterprise Viewpoint
Open Source, Data and Postgres – An Enterprise Viewpoint

presented by Gautam Khanna from Infosys

Data is at the center of all modernization initiatives at the enterprise level. What role does Open Source/FOSS play in this paradigm? How does PostgreSQL fit into the enterprise data landscape? In this session, a ring side view will be presented on how Global 2000 clients are absorbing PostgreSQL into their IT landscape.

09:45 - 10:30 Grand Victoria 1 Keynote
10:30
PGConf Organizers

27th Feb Morning Tea

presented by PGConf Organizers from PGConf India

Tea Break

10:30 - 11:00 Grand Victoria 1 Other
11:00
Krishnaswamy Subramanian Nithya Natarajan

Taming 100+ PostgreSQL instances on the Cloud

presented by Krishnaswamy Subramanian, Nithya Natarajan from ThoughtWorks

Kubernetes lets you deploy applications in ways that are highly available and resilient, and can utilize the underlying resources more efficiently. This can bring huge cost savings to the business, especially when you’re entrusted with running PostgreSQL clusters on Kubernetes, rather than over traditional VMs.

In this talk, we share our experiences of running and managing 100+ PostgreSQL i...

more

11:00 - 11:40 Robusta + Arabica Case Study
Robert Haas

Avoiding, Detecting, and Recovering From Data Corruption
Avoiding, Detecting, and Recovering From Data Corruption

presented by Robert Haas from EnterpriseDB

Hardware or software failure or user error can result in your PostgreSQL database becoming corrupted. In this talk, I'll discuss some things that you can do to minimize the likelihood that your database will become corrupted. In case that doesn't work, or you already have a corrupted database, I'll also discuss signs you may be able to spot that will tell you that your database has become ...

more

11:00 - 11:40 Grand Victoria 1 Database Administration
Oleg Bartunov

Full Text Search in PG12

presented by Oleg Bartunov from Moscow University, Postgres Professional

Full-Text Search ( FTS ) is a search for the documents, which satisfy query and, optionally, return them in some order. The most usual case is to find documents containing all query terms and return them in order of their similarity to the query. Notions of query and similarity are very flexible and depends on application. Document can live on a hard drive or to be completely virtual as a resu...

more

11:00 - 11:40 Grand Victoria 2 Application Developer
11:45
Apoorva Aggarwal

Why physical storage of your database tables might matter

presented by Apoorva Aggarwal from Grofers India Pvt Ltd

SQL Query on a database table running slow? Let's create an index on the table. The query is still running slow although the query planner says the index is being utilized. What do we do next?

This talk is about a time when we were building personalized recommendations for our customers and were faced with high latencies in our systems. We pre computed relevant item recommendations for ea...

more

11:45 - 12:25 Grand Victoria 2 Application Developer
Avinash Vallarapu Jobin Augustine

25 Interesting Features of PostgreSQL 12
PostgreSQL 12

presented by Avinash Vallarapu, Jobin Augustine from Percona

  • PostgreSQL continued to be the DBMS of the year for 2018. An interesting fact is that there is a new release every year. So we have another new release this year, PostgreSQL 12. It is planned to be released in the third quarter of the year 2019. There are a lot of improvements in partitioning, query planner, Indexing and some SQL features, etc. Among all of the interesting features for develo...
more

11:45 - 12:25 Grand Victoria 1 Database Administration
Vaibhav Dalvi

Journey of the Query from SELECT to Result set.

presented by Vaibhav Dalvi from EnterpriseDB

Many of the users and ‘wanting to be postgres developers’ wonder what really happens when a SQL is issued over PSQL prompt and till the result is shown on prompt(specially SELECT queries). During this presentation I will like to take the audience through the different phases of query when one types “SELECT * FROM mytable WHERE b = 20”. The presentation will first list out the phases and la...

more

11:45 - 12:25 Robusta + Arabica Database Engine Developers
12:30
Amit Sharma

Understanding Backup
Types of Backups

presented by Amit Sharma from EnterpriseDB

In order to get the maximum reliability, backups play a vital role to ensure that you have all the data required to recover from any eventuality. There are multiple methods available with which you can take a backup and one needs to plan and understand which method suits them the best. We will be discussing various environments depending on size and recovery methods to give you a clear view of ...

more

12:30 - 13:10 Grand Victoria 2 Database Administration
Anastasia Lubennikova

B-tree indexes - learn more about the heart of PostgreSQL

presented by Anastasia Lubennikova from Postgres Professional

B-tree index is the most common index type. Most if not all of the modern DBMS use it. The data structure and concerned algorithms are really mature, there are about 40 years of development. And PostgreSQL's B-tree is not an exception. It's full of complicated optimizations of performance, concurrency and so on. But there're still many ways to improve it.

This talk gives you a deep dive into...

more

12:30 - 13:10 Grand Victoria 1 Database Administration
13:15
PGConf Organizers

27th Feb, Lunch

presented by PGConf Organizers from PGConf India

Lunch

13:15 - 14:15 Grand Victoria 1 Other
14:15
Venkat Susarla Raman

Migration - The Expedition

presented by Venkat Susarla, Raman from Societe Generale Global Solution Centre

PostgreSQL is our go-to relational database for all new applications and also target for migrations. As we are also involved in migration processes, we have chosen to share our processes, the joys (and tears) of our experiences, what worked well and not so well. To make our lives easier we’ve decided to work and contribute on tooling associated with migrations, most notably ora2pg and our own ...

more

14:15 - 14:55 Grand Victoria 2 Case Study
Simon Riggs

Schema Change and Schemaless
Schema Change and Schemaless

presented by Simon Riggs from 2ndQuadrant

How does PostgreSQL cope with schema change on production databases? What functions are available and how do we use them? What other features are on the roadmap? Is a Schemaless approach to data management via JSON a valid alternative approach? What other issues are faced if you adopt that approach? What improvements might we expect in the future for schemaless?

14:15 - 14:55 Grand Victoria 1 Database Administration
15:00
Pavan Deolasee

Recent advances in addressing key challenges around MVCC

presented by Pavan Deolasee from 2ndQuadrant

PostgreSQL’s Multi-Version Concurrency Control provides many nice properties, including read and write scalability. But it has also been a constant source of irritation and problems. In the last few years, significant work has been done in this area and a lot of work is in pipeline. In this talk, we will discuss those improvements, how to make use of those and what’s likely to come in future re...

more

15:00 - 15:40 Grand Victoria 1 Database Administration
Denis Mekhanikov

How to boost and scale Postgres - from sharding to in-memory data grids

presented by Denis Mekhanikov from GridGain

Businesses are accumulating data at enormous rates requiring huge amounts of storage. Due to this, many industry players tend to predict Postgres' extinction. Nevertheless, most businesses have Postgres deployments for decades and continue doing so regardless of the advancement in big data, mobile, IoT, and all other revolutions that contribute to data generation.

So, how does Postgres manag...

more

15:00 - 15:40 Grand Victoria 2 Database Administration
15:45
PGConf Organizers

27th Feb Evening Tea

presented by PGConf Organizers from PGConf India

Tea Break

15:45 - 16:15 Grand Victoria 1 Other
16:15
PGConf Organizers

Evening Commercial Keynotes

presented by PGConf Organizers from PGConf India

Commercial Keynotes

16:15 - 17:00 Grand Victoria 1 Other
17:00
PGConf Organizers

Lightning Talk Day1

presented by PGConf Organizers from PGConf India

Lightning Talk Day1

17:00 - 17:45 Grand Victoria 1 Other
19:00
PGConf Organizers

Dinner

presented by PGConf Organizers from PGConf India

Dinner

19:00 - 22:00 Grand Victoria 1 Other
2020-02-28
09:00
Marc Linster

The future of Postgres in a multi-cloud world
The future of Postgres in a multi-cloud world

presented by Marc Linster from EnterpriseDB

Postgres has won the race. It is the undisputed leader of relational databases for new and modern applications. This presentation will reflect on how customers take advantage of this new situation, how they deal with the complexity, and how they take advantage of Postgres as the universal data platform that is available in containers, in every cloud, in every data centre and on every developer ...

more

09:00 - 09:40 Grand Victoria 1 Keynote
09:45
PGConf Organizers

Marketing Talks

presented by PGConf Organizers from PGConf India

Marketing Talks

09:45 - 10:30 Grand Victoria 1 Other
10:30
PGConf Organizers

28th Feb, Morning Tea

presented by PGConf Organizers from PGConf India

Tea Break

10:30 - 11:00 Grand Victoria 1 Other
11:00
Sachin Kotwal

Sharding in PostgreSQL

presented by Sachin Kotwal from 2ndQuadrant

Sharding in PostgreSQL

1. How to achieve Sharding in PostgreSQL

This section will give details of PostgreSQL Sharding prerequisite (required extensions and sample example).

  • Sharding with inheritance based partitioning : Demo example for Sharding with inheritance based partitioning.

  • Sharding with declarative partitioning : Demo example for Sharding with inheritance based...

more

11:00 - 11:40 Robusta + Arabica Database Administration
Jim Mlodgenski

Top 10 Mistakes When Migrating From Oracle to PostgreSQL

presented by Jim Mlodgenski from Amazon Web Services

As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just by not understanding how PostgreSQL is different than Oracle. In this talk, we discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action.

11:00 - 11:40 Grand Victoria 1 Application Developer
Ashu Pachauri

PostgreSQL: Pushing the limits on a single machine

presented by Ashu Pachauri from Clarisights

With more than 2 billion writes and 400 billion records read per day on a single machine, this talk is the story of how we, at Clarisights, scaled a single PostgreSQL instance more than 50x in last one year.

I'll outline the approaches we took to scale our use case on PostgreSQL, including how we identified and implemented the avenues for scaling both reads and writes, sequen...

more

11:00 - 11:40 Grand Victoria 2 Case Study
11:45
Abhijit Menon-Sen

Locks in Postgres

presented by Abhijit Menon-Sen from 2ndQuadrant

Postgres uses locks at every level in order to support concurrent operations. These include spinlocks, lightweight locks, and regular (heavyweight) locks. Each of these lock types has different properties and applications, but they all have a direct impact on performance and scalability. Understanding how these locks are used and how they interact can help to understand how your server will per...

more

11:45 - 12:25 Grand Victoria 1 Database Administration
Jobin Augustine

Deeper Understanding of PostgreSQL Execution Plan : At plan time and run time

presented by Jobin Augustine from Percona

Right execution plans can deliver maximum performance and throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter and join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new versio...

more

11:45 - 12:25 Robusta + Arabica Application Developer
Kaushik Iyer

Real time data streaming in PostgreSQL

presented by Kaushik Iyer from Endurance International Group, APAC

Real time data streaming of any Data Modification event on the database can prove to be instrumental as a form of derived event sourcing to update heterogenous and non slave data stores. PostgreSQL out of the box provides functionalities and settings which can enable the generation of such events. When combined with services like Debezium which can monitor and record the events we get a pip...

more

11:45 - 12:25 Grand Victoria 2 Case Study
12:30
Rushabh Lathia

Contributing to PostgreSQL Open Source Community: Viewing PostgreSQL from different angles.

presented by Rushabh Lathia from EnterpriseDB India Pvt. Ltd.

PostgreSQL always encourages everyone to submit the patches for the features they would like to see in PostgreSQL and always encourages them to participate in the goal to make the PG as user-friendly. Any PostgreSQL user would like to get involved in the process or would like to contribute to back to the PG but the question is HOW?

One area where PG falls short is finding enough reviewers...

more

12:30 - 13:10 Grand Victoria 1 Other
Ivan Panchenko

Practical JSON

presented by Ivan Panchenko from Postgres Professional

This talk describes some practical cases of JSON usage with the compendium of corresponding PostgreSQL JSON tools: SQL functions and operators, including the new ones introduced in PostgreSQL 12 according to SQL:2016 standard, JSQuery extension, aggregates, recursive CTE, special indexes for JSON search, JSON support in server-side procedural languages. The talk is illustrated by numerous examp...

more

12:30 - 13:10 Grand Victoria 2 Application Developer
13:15
PGConf Organizers

28th Feb, Lunch

presented by PGConf Organizers from PGConf India

Lunch

13:15 - 14:15 Grand Victoria 1 Other
14:15
Tarun Garg

Looking beyond B-Tree Index for performance optimizations
Indexing also has their limits and what do to do in those cases?

presented by Tarun Garg from Engineering Lead @ SquadVoice

When thinking about optimizations in SQL queries, we often only think about changing the structure of SQL queries, avoiding joins or implementing B-tree indexing, but the truth of the matter is they only work up to a certain extent.

e.g. when data to be fetched by SQL becomes huge, indexing like techniques(specially b-tree) also does not provide many benefits over no indexing because of pla...

more

14:15 - 14:55 Grand Victoria 2 Database Administration
Beena Emerson

The Truth about Partitions

presented by Beena Emerson from EnterpriseDB

A native partitioning system was added in PostgreSQL 10 and it has since evolved considerably. In PostgreSQL 13 the existing Postgres benchmarking tool pgbench was extended to allow testing for range and hash partitions.

Choosing a good partition strategy is not a child's play. Partition done wrong can lead to massive performance deterioration.

This talk will summarise all the features a...

more

14:15 - 14:55 Grand Victoria 1 Database Administration
15:00
Nikhil Sontakke

Toward full ACID distributed transaction support with Foreign Data Wrapper
Toward full ACID distributed transaction support with Foreign Data Wrapper

presented by Nikhil Sontakke from 2ndQuadrant

PostgreSQL has Foreign Data Wrapper feature and it is the powerful feature to access the distributed data across heterogenous data stores. FDW became writable at PostgreSQL 9.3 therefore PostgreSQL with FDW has potential to become distributed database supporting reads and writes.

However one of the biggest missing piece is transaction management for distributed transactions. Currently atomic...

more

15:00 - 15:40 Grand Victoria 2 Database Engine Developers
Asim Rama Praveen

Fault injection facility for PostgreSQL developers

presented by Asim Rama Praveen from Pivotal Software Inc

How to write a isolation/TAP test to validate crash recovery such that the server crashes after writing a commit record but before updating CLOG? How to test whether a terminate signal that arrives exactly after writing a PREPARE record is handled correctly?

It is possible to come up with many more scenarios like these where existing test frameworks such as regress/TAP/isolation fall short....

more

15:00 - 15:40 Grand Victoria 1 Database Engine Developers
15:45
PGConf Organizers

28th Feb, Evening Tea

presented by PGConf Organizers from PGConf India

Tea Break

15:45 - 16:15 Grand Victoria 1 Other
16:15
PGConf Organizers

Lightning Talk Day2

presented by PGConf Organizers from PGConf India

Lightning Talk Day2

16:15 - 17:00 Grand Victoria 1 Other
17:00
PGConf Organizers

Closing Note

presented by PGConf Organizers from PGConf India

Closing Note

17:00 - 17:30 Grand Victoria 1 Other