Program for PGConf India, 2023

2023-02-22
09:00
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
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
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
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
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
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
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
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

Run HTAP workloads on PostgreSQL with AlloyDB on Google Cloud

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
Franck Pachot

pg_hint_plan - get the right plan without surprises

presented by Franck Pachot from Yugabyte

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 through understanding and examples of how to use pg_hint_plan in a predictable way. It is also a good occasion to understand the access paths, j...

more

10:45 - 11:30 Grand Victoria 2 Application Developer
Vaijayanti Bharadwaj

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

presented by Vaijayanti Bharadwaj from EnterpriseDB

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, given requirements on performance and Elasticsearch limitations around support for one to many and many to many relationships • Making sure the cluster is ...

more

10:45 - 11:30 Grand Victoria 1 Case Study
Azman Agung Nugraha

Data Security: Consideration and Ways to Secure PostgreSQL Instances.

presented by Azman Agung Nugraha from Ashnik

The world we are living in is focused on the growing value of data, especially personal data. That is heightened by the increasing number and severity of data breaches accompanied by a massive list of data privacy regulations with serious consequences for noncompliance. In addition, the global pandemic is accelerating data migration while increasing the pace of digital transformation and expo...

more

10:45 - 11:30 Robusta + Arabica Database Administration
11:30
Yugundhar Kalikapuram Ramu Jagini

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

presented by Yugundhar Kalikapuram, Ramu Jagini from AWS

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 are scenarios which improved on performance responses to application, by enlightening what PostgreSQL do best at query Optimiser plan decisions. ...

more

11:30 - 12:15 Robusta + Arabica Application Developer
M N Manikantan Srinivasarao Oguri Srikanth Medikonda

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, Srikanth Medikonda, M N Manikantan from Acresium

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:

PostgreSQL, the most advanced open source database, has become our go-to relational database fo...

more

11:30 - 12:15 Grand Victoria 2 Case Study
Robert Haas

Understanding and Fixing Autovacuum
Understanding and Fixing Autovacuum

presented by Robert Haas from EnterpriseDB

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 determine why autovacuum is not performing as per expectations and how you can resolve issues that you may be facing.

11:30 - 12:15 Grand Victoria 1 Application Developer
12:15
Divya Sharma

Introduction to 'WITH' Queries and their Materialization

presented by Divya Sharma from Amazon Web Services

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 explain the idea of how are CTEs planned and executed in different versions of PostgreSQL and when if you...

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

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 thinking of database servers as black boxes, but as we scale, the internals and architecture become more and more important. This talk focus...

more

12:15 - 13:00 Grand Victoria 2 Application Developer
Jobin Augustine

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

presented by Jobin Augustine from Percona

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

12:15 - 13:00 Robusta + Arabica Case Study
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

How to identify and tune PostgreSQL performance issues using wait events

presented by Sameer Kumar from Amazon Web Services

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_stat_activity view and identify what’s blocking a particular query. In this talk we will cover how you can use this information to identify ...

more

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

Journey of the DML queries

presented by Vaibhav Dalvi from EnterpriseDB

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 SQL is issued over PSQL prompt and till the data is inserted/updated/deleted (i.e DML queries). During this p...

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

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 likes of mysql didn't.
  4. How we improved query performances by database tuning and using materialized views.
  5. Using post...
more

14:00 - 14:45 Grand Victoria 2 Case Study
14:45
Srinivasa Vasu Abhishek Mishra

Identity Crisis: through the lens of a developer

presented by Srinivasa Vasu, Abhishek Mishra from Yugabyte

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 patterns. We also gravitate towards a distributed Postgres SQL, in the end, to understand how t...

more

14:45 - 15:30 Robusta + Arabica Database Engine Developers
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
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
PGConf Organizers

Diamond Sponsor Keynote by AWS

presented by PGConf Organizers from PGConf India

Diamond Sponsor Keynote by AWS

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
Hannu Krosing

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

presented by Hannu Krosing from Google

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. Often the choice is just between SQL, pl/pgsql, tcl, perl, JavaScript, python and R and even some of these may not be availa...

more

11:15 - 12:00 Grand Victoria 2 Application Developer
Vigneshwaran C

Internals of logical replication

presented by Vigneshwaran C from Fujitsu

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
Jobin Augustine

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

presented by Jobin Augustine from Percona

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 performance views (pg_stat_*)
Have you ever felt that there is too much performance and monitoring data and how to make sense of...

more

11:15 - 12:00 Robusta + Arabica Database Administration
12:00
Dilip Kumar

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

presented by Dilip Kumar from EnterpriseDB

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 these problems become worst when they happen in presence of long-running queries. Then we will discuss some of the internal designs to unde...

more

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

How to migrate logical replication slot to new primary during physical cluster switchover

presented by Tushar Takate, Anubhav from Apple

Objective


To present the architecture of the solution which we have designed for migrating logical replication slot when there is a situation of physical cluster switchover/failover.

What are we going to talk about?


We will be talking about:

A) How this solution/idea is different than others?

B) How to move/res...

more

12:00 - 12:45 Robusta + Arabica Database Administration
Robins Tharakan

Bug hunting in the postgres ecosystem

presented by Robins Tharakan from Amazon Web Services

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 ecosystem using a test-framework that I've been developing / using. The talk tries to cover some learnings, best-p...

more

12:00 - 12:45 Grand Victoria 2 Application Developer
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

Different rollback plans during major version upgrades

presented by Nikhil Shetty, Siva Mekala from Apple

Objective


To have the best rollback plan during 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) Rollback after completion of upgrade

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

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 explains the background and importance of MERGE. The problems the MERGE can solve? How this feature can...

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

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 of facing several issue like mention below: Too Many Connections during performance testing Unused indexes and duplicate indexes Tab...

more

14:00 - 14:45 Robusta + Arabica Database Administration
14:45
HariKrishna Rajesh Madiwale

Your own database security Inspector with alerting mechanism

presented by HariKrishna, Rajesh Madiwale from AWS

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 activities like granting/revoking un-authorised access role/privileges by particular user(s). This solution further extends the ...

more

14:45 - 15:30 Robusta + Arabica Database Administration
Rejo Oommen

Running Production worldloads 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
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