Program for PGConf India, 2023

2023-02-22
09:00
Franck Pachot

Distributed SQL: Why and How? (with PostgreSQL-compatible YugabyteDB)

presented by Franck Pachot from Yugabyte

In this training, you will learn the limitations of monolithic PostgreSQL for High Availability and get insights on the future of databases in a cloud-native environment with sharding, distribution, and replication. The training will cover:

Introduction and concepts

  • High Availability with PostgreSQL (Streaming replication, Patroni)
  • RPO, RTO, Split Brain, Data Loss beyond marketing s...
more

09:00 - 12:30 Grand Victoria 2 Training
Sai Parthasaradhi

Building strategies for migrating different database systems to PostgreSQL
Database Migration Lifecycle and Best Practises

presented by Sai Parthasaradhi from AWS

This training walks through the heterogeneous database migration lifecycle and its different phases. It dives deep into best practices and real life customer migration use cases using open source tools. We will cover migrations from Oracle to PostgreSQL and explain how these strategies can be applied to other source engines as well.

Format of the training : Theory and anecdotes of customer...

more

09:00 - 12:30 Robusta Training
Abhijeet Rajurkar

Real time Analytics with PostgreSQL
Real time Analytics with PostgreSQL

presented by Abhijeet Rajurkar from Google

This training talks about how real time analytics can be delivered with different flavours of PostgreSQL. It gives insights into best practices for deploying real time light analytics workloads and how postgres can be leveraged for HTAP workloads . We will cover this with a hands-on lab which participants can experience and try in the room.

Format of the training : Hands on lab and demo ...

more

09:00 - 12:30 Arabica Training
Bruce Momjian

Mastering PostgreSQL Administration

presented by Bruce Momjian from EnterpriseDB

This talk is designed for PostgreSQL administrators. It covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and disaster recovery. It shows how to control host connectivity, configure the server, find the query being run by each session, and find th...

more

09:00 - 12:30 Grand Victoria 1 Training
13:00
PGConf Organizers

Training Day Lunch

presented by PGConf Organizers from PGConf India

Training Day Lunch

13:00 - 14:00 Grand Victoria Other
14:00
Jônatas Davi Paganini

Data science with Postgres - introductory training
Learn how to do time series data analysis with Postgresql and TimescaleDB

presented by Jônatas Davi Paganini from Timescale

All your data is on your database, so why do you need to use a third-party programming language to process your data analysis? Now you can do it in the database! With the TimescaleDB toolkit, you can process your data analysis directly in the database.

TimescaleDB is a time-series extension for Postgresql. It also has a data toolkit as an additional extension, which eases all things analyti...

more

14:00 - 17:30 Grand Victoria 2 Training
Hari Kiran

Simplifying the complexity of Database Partitioning

presented by Hari Kiran from OpenSource DB

The recipe for a Flawless implementation of Database Partitioning starting from Data/Table/Schema Discovery to Partitioning the tables with 0 service disruption/downtime.

The Training will focus on: - Benefits of partitioning - What's available for DBAs in latest PG major versions in Partitioning - How-to/When-to use partitioning - Pros/Cons of partitioning - Key differences with DB Sha...

more

14:00 - 17:30 Robusta + Arabica Training
Dinesh Kumar Chemuduru

Cloud agnostic BCP/high available compliance Of PostgreSQL
Cloud agnostic BCP/high available compliance Of PostgreSQL

presented by Dinesh Kumar Chemuduru from Tessell

In this training, we would be discussing about

  • Required HA and DR strategies of a business
  • We talk and train about the native features we have in PostgreSQL to achieve BCP

    • Logical Replication
    • Streaming Replication
    • Object specific replication
    • Kafka Stream replication
    • Pull - FDW replication
    • Trigger specific replication
  • We talk and train about Open source...

more

14:00 - 17:30 Grand Victoria 1 Training
2023-02-23
09:00
PGConf Organizers

Opening Remarks

presented by PGConf Organizers from PGConf India

welcome note

09:00 - 09:15 Grand Victoria Other
09:15
Dr Kailash Nadh

The joy and profitability of self-hosting FOSS
The joy and profitability of self-hosting FOSS

presented by Dr Kailash Nadh from Zerodha

Self-hosting FOSS over managed services is still somewhat a touchy topic. There is a lot of subtle FUD and FOMO out there that paint pictures of maintenance headaches and self-hosting risks. This isn't true. Many battle tested FOSS like Postgres are highly underrated for their resilience and easy of maintenance. Self-hosting gives total control, liberty over an organisation's technology stack i...

more

09:15 - 10:00 Grand Victoria Keynote
10:00
Subhash Guddad

Google Cloud : The best home for your PostgreSQL workloads

presented by Subhash Guddad from Google

This session will cover the latest addition to the Google Cloud database portfolio, AlloyDB for PostgreSQL, which provides a commercial grade PostgreSQL-compatible database to run transactional and analytical workloads on the same database.

10:00 - 10:20 Grand Victoria Sponsor Keynote
10:15
PGConf Organizers

Tea Break

presented by PGConf Organizers from PGConf India

Day 1 Morning Tea Break

10:15 - 10:45 Grand Victoria Other
10:45
Vaijayanti Bharadwaj

Full Text Search: Capabilities of PostgreSQL and a Comparison with Elasticsearch Using Wikipedia Dataset

presented by Vaijayanti Bharadwaj from EnterpriseDB

Checkout the slides

Background

Today, Elasticsearch is a very popular datastore for full-text searches. Using Elasticsearch has certain considerations such as: • Maintaining a separate cluster just for keeping a full-text index • A proper schema design, gi...

more

10:45 - 11:30 Grand Victoria 1 Case Study
Nimish Avarsekar

Partition elimination in PostgreSQL and Greenplum

presented by Nimish Avarsekar from VMware

Checkout the slides

PostgreSQL supports partitioning of the tables. Though if they grow large in terms of number of child tables and/or store large amounts of data become inefficient in-terms of query planning and memory usage for execution. Greenplum Database, fork of PostgreSQL, has long supported partitioning tab...

more

10:45 - 11:30 Robusta + Arabica
Franck Pachot

pg_hint_plan - get the right plan without surprises

presented by Franck Pachot from Yugabyte

Checkout the slides

I use pg_hint_plan to learn about the optimizer, to understand the query planner choices, and, sometimes work around a problem in production. But hinting is not easy. Fixing the exact plan needs more than one hint. In this live demo session, we will go th...

more

10:45 - 11:30 Grand Victoria 2 Application Developer
11:30
Yugundhar Kalikapuram

Performance use cases and best practices - PL/pgSQL code conversion

presented by Yugundhar Kalikapuram from AWS

Checkout the slides

Objective: Depicting & Trouble-shooting challenges for Procedural Code of PostgreSQL and performance bench-marking. Rearchitecting techniques applied, specially in heterogenous migration from various source databases as Oracle/SQLServer. Following ar...

more

11:30 - 12:15 Robusta + Arabica Application Developer
Robert Haas

Understanding and Fixing Autovacuum
Understanding and Fixing Autovacuum

presented by Robert Haas from EnterpriseDB

Checkout the slides

In this talk, I'll explain how autovacuum decides which tables to vacuum and analyze and when to perform these operations, with an emphasis on how these algorithms can go wrong. Then, I'll discuss troubleshooting steps that you can take on your system to ...

more

11:30 - 12:15 Grand Victoria 1 Application Developer
Srinivasarao Oguri

How we are managing $675B+ assets for world’s most sophisticated asset managers and why we are moving from managed PostgreSQL to self-hosted community PostgreSQL

presented by Srinivasarao Oguri from Arcesium

Checkout the slides

About us:

Arcesium is an advanced data, operations and analytics platform managing $675B+ assets for world's most sophisticated asset managers and financial services organizations and we are backed by D.E.Shaw group, Blackstone Alternative Asset management and J.P.Morgan.

**Abstract:...

more

11:30 - 12:15 Grand Victoria 2 Case Study
12:15
Jobin Augustine

Reducing PostgreSQL Costs in the Cloud
Reducing PostgreSQL Costs in the Cloud

presented by Jobin Augustine from Percona

Checkout the slides

In the face of economic uncertainty and a possible recession, many companies are trimming expenses, freezing hiring, and, in some cases, laying off staff.

But what if you could cut costs without negatively impacting resources or headcount? Better yet, what if you could free up enough budget ...

more

12:15 - 13:00 Robusta + Arabica Case Study
Divya Sharma

Introduction to 'WITH' Queries and their Materialization

presented by Divya Sharma from Amazon Web Services

Checkout the slides

In this session I will talk about : 1. What are Common Table Expressions 2. Advantages of using them - readability, re-usablity, tree traversals etc. 3. What are Materialized CTEs - what changed from version 12+ for the planning/execution of CTEs 4. Should I use CTEs?

The talk is to ...

more

12:15 - 13:00 Grand Victoria 1 Database Administration
Christopher Travers

Redis vs PostgreSQL: Making the Right Choice

presented by Christopher Travers from Timescale

Checkout the slides

With the rise of NoSQL databases, a number of falsehoods have flourished regarding how to choose a database engine. This talk focuses specifically on Redis and PostgreSQL, and why one might choose one or the other.

At small scales, we can often get by thin...

more

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

Day 1 Lunch

presented by PGConf Organizers from PGConf India

Lunch Break

13:00 - 14:00 Grand Victoria Other
14:00
Sameer Kumar Roneel Kumar

How to identify and tune PostgreSQL performance issues using wait events

presented by Sameer Kumar, Roneel Kumar from Amazon Web Services

Checkout the slides

If you run highly concurrent workload on PostgreSQL, you must have run into some or the other performance issues. Do you know PostgreSQL provides information on where are your queries spending their time via wait events in pg_stat_activity? You can poll pg...

more

14:00 - 14:45 Robusta + Arabica Database Administration
Vaibhav Dalvi

Journey of the DML queries

presented by Vaibhav Dalvi from EnterpriseDB

Checkout the slides

This talk is in continuation with the talk presented in PGConf India, 2020, i.e. Journey of the Query from SELECT to Result set. Many of the users and ‘wanting to be postgres developers’ wonder what really happens when a SQ...

more

14:00 - 14:45 Grand Victoria 1 Database Engine Developers
Satyajit Sarangi

Deep dive of usage of Postgres in Zerodha and our learnings

presented by Satyajit Sarangi from Developer at Zerodha

Checkout the slides

A presentation on how we use Postgres at Zerodha and our learnings:

  1. How we sharded our db (or why we never did for the longest time)
  2. Learnings on many how-tos when creating schemas for us.
  3. Specific usecases where Postgres "just worked" where the...
more

14:00 - 14:45 Grand Victoria 2 Case Study
14:45
Paresh Rathod Sriram Melkote

AlloyDB - Cloud Native Postgres

presented by Paresh Rathod, Sriram Melkote from Google

AlloyDB is a GCP cloud native database with Postgres Kernel and custom storage. AlloyDB utilizes transaction logs to materialize storage blocks offline, offering high throughputs and resilient recovery. AlloyDB also supports replication to managed read pool instances. AlloyDB also has ability to materialize columns selected by ML models into column major formats and utilize them for efficient s...

more

14:45 - 15:30 Grand Victoria 1 Case Study
Maneesh Rawat

Nitro Boost your PostgreSQL Workloads

presented by Maneesh Rawat from Tessell

Ability to convert local NvME storage on Bare metal instances on AWS/Azure into durable , zero data loss Database Infrastructure hence providing a highly performant database compute with upto 2 million IOPS at a fraction of cost.

14:45 - 15:30 Grand Victoria 2 Case Study
Srinivasa Vasu

Identity Crisis: through the lens of a developer

presented by Srinivasa Vasu from Yugabyte

Checkout the slides

This talk will go through the auto-id generation usage patterns involving Sequence, Identity, and UUID from the perspective of a developer. A simple show and tell demos guiding through the interaction between the Application and Postgres layer covering a few optimization techniques based on the usage pattern...

more

14:45 - 15:30 Robusta + Arabica Database Engine Developers
15:30
PGConf Organizers

Tea Break

presented by PGConf Organizers from PGConf India

Afternoon Tea Break

15:30 - 16:00 Grand Victoria Other
16:00
PGConf Organizers

Platinum Sponsor Keynotes

presented by PGConf Organizers from PGConf India

Keynote by 3 Platinum Sponsors

16:00 - 16:30 Grand Victoria
16:30
PGConf Organizers

Day 1 Lightning Talks

presented by PGConf Organizers from PGConf India

Lightning Talks on Day One

16:30 - 17:30 Grand Victoria Other
19:00
PGConf Organizers

Conference Dinner

presented by PGConf Organizers from PGConf India

Conference Dinner

19:00 - 22:00 Grand Victoria Other
2023-02-24
09:15
Bruce Momjian

Future Postgres Challenges

presented by Bruce Momjian from EnterpriseDB

Postgres has been a vibrant project for decades, and probably will be popular for decades to come. However, as with any complex endeavor, challenges are always lurking. This talk explores the many project, competitive, and technical challenges in the future that could derail its success. By exploring these challenges, we will be better able to avoid them.

Slides are at https://momjian.us/mai...

more

09:15 - 10:00 Grand Victoria Keynote
10:00
Vamsi Gelli HariKrishna

Instant and fine-grained scaling with Amazon Aurora Serverless v2

presented by Vamsi Gelli, HariKrishna from AWS

Amazon Aurora Serverless v2 (ASv2) is an on-demand, auto-scaling configuration for Aurora that automatically adjusts database capacity based on your application's needs. With ASv2 you can scale database workloads instantly to hundreds of thousands of transactions in a fraction of a per second and adjust capacity in fine-grained increments to provide just the right amount of database resources f...

more

10:00 - 10:20 Grand Victoria Sponsor Keynote
10:15
PGConf Organizers

Marketing Talks by Sponsors

presented by PGConf Organizers from PGConf India

Marketing talks by sponsors.

10:15 - 10:45 Grand Victoria
10:45
PGConf Organizers

Tea Break

presented by PGConf Organizers from PGConf India

Day 2 Morning Tea Break

10:45 - 11:15 Grand Victoria Other
11:15
Jobin Augustine

Highly effective Troubleshooting of performance and stability problems in a PostgreSQL server

presented by Jobin Augustine from Percona

Checkout the slides

Introduction.

Have you ever been in a database emergency and needed real quick pinpointing information on what is wrong with a PostgreSQL instance/database?
Are you looking for a good Analysis and meaningful conclusions using the data presented by PostgreSQL perfo...

more

11:15 - 12:00 Robusta + Arabica Database Administration
Vigneshwaran C

Internals of logical replication

presented by Vigneshwaran C from Fujitsu

Checkout the slides

The following topics will be covered as part of the presentation: 1) Architecture of logical replication 2) Publisher introduction 3) Subscriber introduction 4) Data syncronization introduction 5) Logical decoding 6) Replication slot 7) output plugin

11:15 - 12:00 Grand Victoria 1 Database Engine Developers
Hannu Krosing

Writing Your Server-Side Functions in any language
from `pl/v8` to `pl/<any>`

presented by Hannu Krosing from Google

Checkout the slides

PostgreSQL is an amazing multi-language development platform where you can mix and match programming languages and seamlessly call one language from other.

Still you are currently limited by what is made available by the developers or your Cloud provider....

more

11:15 - 12:00 Grand Victoria 2 Application Developer
12:00
Robins Tharakan

Bug hunting in the postgres ecosystem

presented by Robins Tharakan from Amazon Web Services

Checkout the slides

Bug-hunting in the postgres ecosystem

Duration: It would be good to have at least 45min to go into some depth. More would help in answering queries, if any.

Brief

The talk would focus on my experience using SQLSmith (and other tools) exploring bugs in the postgres ec...

more

12:00 - 12:45 Grand Victoria 2 Application Developer
Dilip Kumar

Rare but extremely challenging Postgres Performance Problems. How to diagnose and overcome

presented by Dilip Kumar from EnterpriseDB

Checkout the slides

In this talk, we will discuss some of the rare but challenging problems with PostgreSQL in heavily loaded systems. The main problems we are going to discuss are related to subtransaction overflow, multi-xact usage-related issues. We will also discuss how th...

more

12:00 - 12:45 Grand Victoria 1 Database Engine Developers
Tushar Takate Anubhav Jain

Migrate logical replication during physical cluster switchover

presented by Anubhav Jain, Tushar Takate from

Objective


Present the architecture for migrating logical replication to new primary after of physical cluster switchover/failover.

What are we going to talk about?


We will be talking about:

A) How is this solution different than others?

B) How to move/reset restart_lsn in the past of logical replication slot wh...

more

12:00 - 12:45 Robusta + Arabica Database Administration
13:00
PGConf Organizers

Day 2 Lunch

presented by PGConf Organizers from PGConf India

Day 2 Lunch

13:00 - 14:00 Grand Victoria Other
14:00
Nikhil Shetty Siva Mekala

Rollback: Major Version Upgrade, Minimum Downtime, Multi Terabyte DB

presented by Nikhil Shetty, Siva Mekala from Apple

Objective


To discuss about the rollback option with minimum downtime on a multi terabyte DB after major version upgrade

What are we going to talk about?


We will be talking on what are the different approaches that we can have to roll back to the older version in minimal time.

A) R...

more

14:00 - 14:45 Grand Victoria 2 Database Administration
Shruthi K C

MERGE: Built to Remove Barriers

presented by Shruthi K C from EnterpriseDB

Checkout the slides

Title: MERGE: Built to Remove Barriers Name(s) of speaker & Job title: Shruthi K C, Staff Software Development Engineer 2A, Database Tech Lead

This talk takes through the most awaited feature of Postgres - MERGE SQL command. MERGE is a key feature of Postgres 15. To begin with, the talk e...

more

14:00 - 14:45 Grand Victoria 1 Application Developer
veerendra pulapa

How unused indexes, fragmentation and idle connections slow down DB performance
Connection pooling, Database configuration, maintenance activities and database performance

presented by veerendra pulapa from Ashnik

Checkout the slides

In postgresql setup transactions, users will leverage indexes as an effort to improve their database performance. However the indexes in the table which is frequently use might have some problem regarding its data retrieval performance which is appear because...

more

14:00 - 14:45 Robusta + Arabica Database Administration
14:45
Rejo Oommen

Running Production workloads on Postgres Operators in Kubernetes

presented by Rejo Oommen from Lowe's

Kubernetes has been adopted by a lot of companies over the last few years and running databases on Kubernetes has been evaluated by many of them. In this talk we will be sharing experiences of how at Lowe's we adopted the operator Journey, architected and are successfully running over 500+ Postgres Instances on Kubernetes over the last 2 years with some of the DB sizes at over a TB.

14:45 - 15:30 Grand Victoria 2 Case Study
Rajesh Madiwale

Your own database security Inspector with alerting mechanism

presented by Rajesh Madiwale from Amazon Web Services

Checkout the slides

Several large enterprise customers need to get database users with their actions audited and notified in near realtime for suspicious database activity for corrective action is of prime importance.

A custom audit solution was developed to track the suspicious acti...

more

14:45 - 15:30 Robusta + Arabica Database Administration
15:30
PGConf Organizers

Tea Break

presented by PGConf Organizers from PGConf India

Day 2 Afternoon Tea Break

15:30 - 16:00 Grand Victoria Other
16:00
PGConf Organizers

Day 2 Lightning Talks

presented by PGConf Organizers from PGConf India

Lightning Talks on Day 2

16:00 - 16:30 Grand Victoria Other
16:30
PGConf Organizers

Closing Note

presented by PGConf Organizers from PGConf India

Closing Notes for PGConf India, 2023

16:30 - 17:00 Grand Victoria Other