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 Jobin Augustine, Avinash Vallarapu from Percona

Note: No slides/videos available for trainings.

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

...

more

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

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

presented by Nithya Natarajan, Krishnaswamy Subramanian from ThoughtWorks

Note: No slides/videos available for trainings.

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

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

Note: No slides/videos available for trainings.

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
14:00
Mansur Shaikh

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

presented by Mansur Shaikh from EnterpriseDB

Note: No slides/videos available for trainings.

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

more

14:00 - 17:30 Grand Victoria 1 Training
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 from Microsoft

Note: No slides/videos available for trainings.

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

more

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

Introduction to PL/pgSQL Development

presented by Jim Mlodgenski from Amazon Web Services

Note: No slides/videos available for trainings.

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

more

14:00 - 17:30 Robusta + Arabica 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

Checkout the slides here

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

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

Download slides

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

more

09:45 - 10:30 Grand Victoria 1 Keynote
11:00
Robert Haas

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

presented by Robert Haas from EnterpriseDB

Checkout the slides

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

more

11:00 - 11:40 Grand Victoria 1 Database Administration
Krishnaswamy Subramanian Nithya Natarajan

Taming 100+ PostgreSQL instances on the Cloud

presented by Nithya Natarajan, Krishnaswamy Subramanian from ThoughtWorks

Checkout the slides

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

more

11:00 - 11:40 Robusta + Arabica Case Study
Oleg Bartunov

Full Text Search in PG12

presented by Oleg Bartunov from Moscow University, Postgres Professional

Download slides

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

more

11:00 - 11:40 Grand Victoria 2 Application Developer
11:45
Vaibhav Dalvi

Journey of the Query from SELECT to Result set.

presented by Vaibhav Dalvi from EnterpriseDB

Download slides

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

more

11:45 - 12:25 Robusta + Arabica Database Engine Developers
Apoorva Aggarwal

Why physical storage of your database tables might matter

presented by Apoorva Aggarwal from Grofers India Pvt Ltd

Download slides

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

more

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

25 Interesting Features of PostgreSQL 12
PostgreSQL 12

presented by Jobin Augustine, Avinash Vallarapu from Percona

Download slides

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

11:45 - 12:25 Grand Victoria 1 Database Administration
12:30
Anastasia Lubennikova

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

presented by Anastasia Lubennikova from Postgres Professional

Download slides

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

more

12:30 - 13:10 Grand Victoria 1 Database Administration
Amit Sharma

Understanding Backup
Types of Backups

presented by Amit Sharma from EnterpriseDB

Download slides

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

more

12:30 - 13:10 Grand Victoria 2 Database Administration
14:15
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
Venkat Susarla

Migration - The Expedition

presented by Venkat Susarla from Societe Generale Global Solution Centre

Download slides

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

more

14:15 - 14:55 Grand Victoria 2 Case Study
15:00
Pavan Deolasee

Recent advances in addressing key challenges around MVCC

presented by Pavan Deolasee from 2ndQuadrant

Download slides

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

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

Download slides

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

more

15:00 - 15:40 Grand Victoria 2 Database Administration
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

Download slides

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

more

09:00 - 09:40 Grand Victoria 1 Keynote
11:00
Sachin Kotwal

Sharding in PostgreSQL

presented by Sachin Kotwal from 2ndQuadrant

Download slides

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

11:00 - 11:40 Robusta + Arabica Database Administration
Ashu Pachauri

PostgreSQL: Pushing the limits on a single machine

presented by Ashu Pachauri from Clarisights

Download slides

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

more

11:00 - 11:40 Grand Victoria 2 Case Study
Jim Mlodgenski

Top 10 Mistakes When Migrating From Oracle to PostgreSQL

presented by Jim Mlodgenski from Amazon Web Services

Download slides

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

more

11:00 - 11:40 Grand Victoria 1 Application Developer
11:45
Abhijit Menon-Sen

Locks in Postgres

presented by Abhijit Menon-Sen from 2ndQuadrant

Download slides

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

more

11:45 - 12:25 Grand Victoria 1 Database Administration
Kaushik Iyer

Real time data streaming in PostgreSQL

presented by Kaushik Iyer from Endurance International Group, APAC

Download slides

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

more

11:45 - 12:25 Grand Victoria 2 Case Study
Jobin Augustine

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

presented by Jobin Augustine from Percona

Download slides

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

more

11:45 - 12:25 Robusta + Arabica Application Developer
12:30
Rushabh Lathia

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

presented by Rushabh Lathia from EnterpriseDB India Pvt. Ltd.

Download slides

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

more

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

Practical JSON

presented by Ivan Panchenko from Postgres Professional

Download slides

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

more

12:30 - 13:10 Grand Victoria 2 Application Developer
14:15
Beena Emerson

The Truth about Partitions

presented by Beena Emerson from EnterpriseDB

Download slides

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

more

14:15 - 14:55 Grand Victoria 1 Database Administration
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

Check out the slides here

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

more

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

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

presented by Nikhil Sontakke from 2ndQuadrant

Download slides

PostgreSQL has Foreign Data Wrapper (FDW) functionality and it is a powerful feature to access distributed data from across heterogenous data stores. FDW became writable in PostgreSQL 9.3 and therefore PostgreSQL with FDW has potential to act as a distributed database su...

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

Download slides

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

more

15:00 - 15:40 Grand Victoria 1 Database Engine Developers