Program for PGConf India, 2020
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
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 o...
more 09:00 - 12:30 Grand Victoria 2 Training
PostgreSQL Performance Optimization - A DBA's View
PostgreSQL Performance Optimization - A DBA's View
presented by Hari Kiran from OpenSource DB
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
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
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 Hype...
more 14:00 - 17:30 Grand Victoria 2 Training
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
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
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
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
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 entr...
more 11:00 - 11:40 Robusta + Arabica Case Study
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
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 phas...
more 11:45 - 12:25 Robusta + Arabica Database Engine Developers
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
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...
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
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
Schema Change and Schemaless
Schema Change and Schemaless
presented by Simon Riggs from EDB
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
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
Recent advances in addressing key challenges around MVCC
presented by Pavan Deolasee from EDB
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 ...
more 15:00 - 15:40 Grand Victoria 1 Database Administration
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
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
Sharding in PostgreSQL
presented by Sachin Kotwal from AWS Proserve India LLP
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...
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
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
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
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
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
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
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
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
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
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 Timescale
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
Fault injection facility for PostgreSQL developers
presented by Asim Rama Praveen from IIT Bombay
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