Program for PGConf India, 2023
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...
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 TrainingReal 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 TrainingMastering 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 TrainingTraining Day Lunch
presented by PGConf Organizers from PGConf India
Training Day Lunch
13:00 - 14:00 Grand Victoria OtherData 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 TrainingSimplifying 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 TrainingCloud 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...
Opening Remarks
presented by PGConf Organizers from PGConf India
welcome note
09:00 - 09:15 Grand Victoria OtherThe 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 KeynoteGoogle 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 KeynoteTea Break
presented by PGConf Organizers from PGConf India
Day 1 Morning Tea Break
10:15 - 10:45 Grand Victoria OtherFull 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 StudyPartition 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 + Arabicapg_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 DeveloperPerformance 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 DeveloperUnderstanding 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 DeveloperHow 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 StudyReducing 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 StudyIntroduction 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 AdministrationRedis 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 DeveloperDay 1 Lunch
presented by PGConf Organizers from PGConf India
Lunch Break
13:00 - 14:00 Grand Victoria OtherHow 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 AdministrationJourney 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 DevelopersDeep 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:
- How we sharded our db (or why we never did for the longest time)
- Learnings on many how-tos when creating schemas for us.
- Specific usecases where Postgres "just worked" where the...
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 StudyNitro 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 StudyIdentity 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 DevelopersTea Break
presented by PGConf Organizers from PGConf India
Afternoon Tea Break
15:30 - 16:00 Grand Victoria OtherPlatinum Sponsor Keynotes
presented by PGConf Organizers from PGConf India
Keynote by 3 Platinum Sponsors
16:00 - 16:30 Grand VictoriaDay 1 Lightning Talks
presented by PGConf Organizers from PGConf India
Lightning Talks on Day One
16:30 - 17:30 Grand Victoria OtherConference Dinner
presented by PGConf Organizers from PGConf India
Conference Dinner
19:00 - 22:00 Grand Victoria OtherFuture 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 KeynoteInstant 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 KeynoteMarketing Talks by Sponsors
presented by PGConf Organizers from PGConf India
Marketing talks by sponsors.
10:15 - 10:45 Grand VictoriaTea Break
presented by PGConf Organizers from PGConf India
Day 2 Morning Tea Break
10:45 - 11:15 Grand Victoria OtherHighly 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...
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 DevelopersWriting 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 DeveloperBug 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 DeveloperRare 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 DevelopersMigrate 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 AdministrationDay 2 Lunch
presented by PGConf Organizers from PGConf India
Day 2 Lunch
13:00 - 14:00 Grand Victoria OtherRollback: 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 AdministrationMERGE: 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 DeveloperHow 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 AdministrationRunning 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 StudyYour 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 AdministrationTea Break
presented by PGConf Organizers from PGConf India
Day 2 Afternoon Tea Break
15:30 - 16:00 Grand Victoria OtherDay 2 Lightning Talks
presented by PGConf Organizers from PGConf India
Lightning Talks on Day 2
16:00 - 16:30 Grand Victoria OtherClosing Note
presented by PGConf Organizers from PGConf India
Closing Notes for PGConf India, 2023
16:30 - 17:00 Grand Victoria Other