Program for PGConf India, 2024

2024-02-28
08:00
PGConf Organizers

Conference Registration on Training Day
Conference Registration on Training Day

presented by PGConf Organizers from PGConf India

Conference Registration

08:00 - 09:00 Grand Victoria Other
09:00
HariKrishna

Maintaining your PostgreSQL DB healthy and resilient

presented by HariKrishna from AWS

Ever increasing data volumes and/or traffic put stress on Customer’s databases and leads to performance bottle-necks affecting user experience and increase business risk due to degrading availability and performance. This training will focus on tips/tricks on finding/resolving of PostgreSQL database health issues in the below 5 key areas. The training session will be a mix of theory and hands ...

more

09:00 - 12:30 Grand Victoria A Training
Bruce Momjian

Postgres for All Your Data
Postgres for All Your Data

presented by Bruce Momjian from EnterpriseDB

Three capabilities that make Postgres ideal for today's workloads: extensibility, non-relational data handling, and specialized indexing. This training covers them all.

First, it covers the extensibility built into Postgres from its inception. It also covers data analytics and foreign data wrappers which are part of that. Second, it covers the ability to...

more

09:00 - 12:30 Arabica Training
Alicja Kucharczyk Aditya D

Building AI Applications with Azure OpenAI and PostgreSQL

presented by Alicja Kucharczyk, Aditya D from Microsoft

Join us for an immersive training session that will equip you with the essential skills to integrate Azure Database for PostgreSQL - Flexible Server with Azure OpenAI for building advanced AI applications. In this hands-on lab, you will gain practical experience in provisioning, configuring, and harnessing the power of Azure's flexible PostgreSQL service to create cutting-edge AI applications. ...

more

09:00 - 12:30 Robusta Training
Luigi Nardi

Mastering PostgreSQL parameter tuning: A practical approach

presented by Luigi Nardi from DBtune

This training session will consist of 2 parts. The first is a short presentation that introduces the concept and the basics of database parameter tuning, why it’s so important and the business value that can be realized when systems and applications are optimally tuned. We will explore existing options for addressing this critical task, including manual tuning and existing open-source solutions...

more

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

Training Day Lunch
Training Day Lunch

presented by PGConf Organizers from PGConf India

Training Day Lunch

13:00 - 13:55 Grand Victoria Other
14:00
Bhargav kamineni Sagar Jadhav

PostgreSQL Upgrades
PostgreSQL Upgrades

presented by Bhargav kamineni, Sagar Jadhav from Percona

Postgres Minor version and Major version upgrade strategies

  • Why need to upgrade?
  • Upgrade types - Minor and major version upgrades
  • About Minor version upgrade
  • About Major version upgrade
  • Different ways of major version upgrades
  • Postgres upgrade using pg_dumpall
  • Postgres upgrade using pg_dump
  • Postgres upgrade using pg_upgrade
  • upgrade on RDS
  • Postgres upgrade using l...
more

14:00 - 17:30 Grand Victoria B Training
Abhijeet Rajurkar

Unraveling GEN AI and PG Vector in PostgreSQL
Unraveling GEN AI and PG Vector in PostgreSQL

presented by Abhijeet Rajurkar from Google

In this training we will do a deep dive into implementation of PG Vector and its capabilities.

14:00 - 17:30 Grand Victoria A Training
Franck Pachot

Distributed SQL on containers: YugabyteDB hands-on lab
Distributed SQL on containers: YugabyteDB hands-on lab

presented by Franck Pachot from Yugabyte

Join us for a hands-on lab where we'll dive into Distributed SQL databases, focusing on YugabyteDB—an open-source and PostgreSQL-compatible solution. In this workshop, you'll have the opportunity to install YugabyteDB and test its key features, such as elasticity and resilience. We'll simulate scenarios like adding new containers and failures while running the SQL application.

Throughout the...

more

14:00 - 17:30 Robusta Training
Dinesh Kumar Chemuduru RK Rakesh

PostgreSQL Extensions
PostgreSQL Extensions

presented by Dinesh Kumar Chemuduru, RK Rakesh from Tessell

This training will cover some of the most popular PostgreSQL extensions, their use cases and a deep dive into their usage.

  1. Gain a comprehensive understanding of PostgreSQL extensions and their role in expanding database functionalities.

  2. Explore major extensions, emphasizing PostGIS, pg_routing, hstore, uuid-ossp, pg_trgm, pg_stat_statements, pg_vector, pgbigm, and TimescaleDB.

3....

more

14:00 - 17:30 Arabica Training
2024-02-29
08:00
PGConf Organizers

Conference Registration on Day 1
Conference Registration on Day 1

presented by PGConf Organizers from PGConf India

Conference Registration on Day 1

08:00 - 09:00 Grand Victoria Other
09:00
PGConf Organizers

Opening Remarks
Opening Remarks

presented by PGConf Organizers from PGConf India

Welcome Note

09:00 - 09:15 Grand Victoria Other
09:15
Pavan Deolasee

REPLACEMENT Please note that this talk replaces Postgres Challenges, Commercial & Community; Past, Present & Future

Through the eyes of a long time Indian Community Contributor
Through the eyes of a long time Indian Community Contributor

presented by Pavan Deolasee from EDB

Perspectives by an Indian Community Contributor who has contributed big features like HOT and MERGE into Postgres.

09:15 - 10:00 Grand Victoria Keynote
09:40
Bruce Momjian

Through the eyes of a long time International Community Contributor
Through the eyes of a long time International Community Contributor

presented by Bruce Momjian from EnterpriseDB

Bruce Momjian has been contributing to PostgreSQL since 1996. In this keynote he provides key insights and observations around his journey.

09:40 - 10:25 Grand Victoria Keynote
10:00
Charles Feddersen

All the Postgres Things at Microsoft
All the Postgres Things at Microsoft

presented by Charles Feddersen from Microsoft

Microsoft is investing a lot in Postgres—including in the Postgres core, Citus open source, Patroni, PgBouncer, pgcopydb, pg_cron, & more Postgres extensions. And Microsoft offers two Azure managed services for PostgreSQL, one is regular and one is distributed Postgres built on Citus. In this talk, you’ll get an overview of some of the interesting Microsoft work on Postgres in the last 12 month...

more

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

Tea Break
Tea Break

presented by PGConf Organizers from PGConf India

Day 1 Morning Tea Break

10:20 - 10:50 Grand Victoria Other
10:50
Robert Haas

Incremental Backup for PG17
Incremental Backup for PG17

presented by Robert Haas from EnterpriseDB

Checkout the slides

This talk will be a deep dive into the new incremental backup feature which has been committed for (hopefully) inclusion in PostgreSQL 17.

First, I'll explain how the feature works from a user perspective, and briefly discuss some possible use cases.

Second, I'll disc...

more

10:50 - 11:30 Grand Victoria A Database Engine Developers
Sibu Behera

Seamlessly monitor and troubleshoot your database performance problems with Query Insights for PostgreSQL
Seamlessly monitor and troubleshoot your database performance problems with Query Insights for PostgreSQL

presented by Sibu Behera from Google

Checkout the slides

Enhanced Query Insights empowers DBAs, developers, and IT generalists to detect and troubleshoot database performance problems with ease. With enhanced Query Insights, our users can view richer and near real-time query telemetry and perform ad-hoc analysis to roo...

more

10:50 - 11:30 Grand Victoria B Database Administration
Franck Pachot

A PostgreSQL fork for horizontal scalability: YugabyteDB
architecture and use-cases

presented by Franck Pachot from Yugabyte

Checkout the slides

YugabyteDB is a PostgreSQL fork that has been enhanced to scale horizontally using a Spanner-like storage and transaction architecture. We will highlight the strengths of YugabyteDB - high availability and elasticity. Additionally, we will compare and c...

more

10:50 - 11:30 Robusta + Arabica Database Engine Developers
11:35
Floor Drees

Finding PostgreSQL’s fit in the AI space
Finding PostgreSQL’s fit in the AI space

presented by Floor Drees from Aiven

Checkout the slides

PostgreSQL may not be the first thing that comes to mind when we think about AI, but it's becoming increasingly important for a growing number of users. In this talk, we'll take a look at the current state of AI and explain why PostgreSQL has a potential to play a key r...

more

11:35 - 12:15 Grand Victoria A Application Developer
Alexander Kukushkin

pg_upgrade like a boss!

presented by Alexander Kukushkin from Microsoft

Checkout the slides

Upgrading a database cluster can be a complex and time-consuming process. While there are several methods for upgrade, such as dump/restore and logical replication, pg_upgrade is a powerful tool that allows users to upgrade a cluster with acceptable and predictable do...

more

11:35 - 12:15 Grand Victoria B Database Administration
Tushar Amrit

Incremental Materialized Views 101

presented by Tushar Amrit from Bloomberg

Checkout the slides

THE FASTEST DATABASE QUERY WAS THE ONE THAT WASN’T EXECUTED

Nobody can have control over the ever-expanding datasets and increasingly complex queries at any organization. The role of materialized views in database management for solving these scenarios is paramo...

more

11:35 - 12:15 Robusta + Arabica Case Study
12:20
Sachin Khanna

Unlocking the Power of Vector Similarity Search with pgvector

presented by Sachin Khanna from AWS

Checkout the slides

With the rise of generative AI, vector embeddings have become the key to enabling powerful applications like large language models. However, storing and searching vector data is not feasible option for traditional databases.

In this presentation, we will explore pgve...

more

12:20 - 13:00 Grand Victoria A Application Developer
Timofey Kulin

YDB — Adding PostgreSQL compatibility to a Distributed SQL database

presented by Timofey Kulin from YDB

Checkout the slides

YDB is a strongly consistent distributed database for mission-critical workloads with more than a decade of history that has been published to open-source in 2022. It was built from scratch with its own SQL dialect, API and query execution l...

more

12:20 - 13:00 Robusta + Arabica Database Engine Developers
Jelte Fennema-Nio

Postgres load balancing is secretly broken: The cancellation problem

presented by Jelte Fennema-Nio from Microsoft

Checkout the slides

On certain workloads a single Postgres server cannot deliver the desired performance. If the traffic is read heavy, you could already resolve this by adding read replicas. If the traffic is write heavy then the Citus comes to the rescue.

In both cases the queries ...

more

12:20 - 13:00 Grand Victoria B Database Administration
13:05
PGConf Organizers

Day 1 Lunch
Day 1 Lunch

presented by PGConf Organizers from PGConf India

Lunch on Day 1

13:05 - 14:00 Grand Victoria Other
14:00
Rakesh Sharma

An Introduction to PostGIS, H3 and its Integration with Greenplum

presented by Rakesh Sharma from vmware inc.

Checkout the slides

Greenplum Database is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads. MPP (a shared-nothing architecture) refers to systems...

more

14:00 - 14:40 Robusta + Arabica Application Developer
Nishchay Kothari

Why Your Security Best Practices Don’t Work

presented by Nishchay Kothari from Fujitsu

Checkout the slides

Why Your Security Best Practices Don’t Work

Data breaches damage a company's reputation, destroy customer confidence, and can have major financial and legal implications. But you’re ahead of the game, and have adopted new PostgreSQL solution wit...

more

14:00 - 14:40 Grand Victoria A Database Administration
Ashutosh Bapat

Postgres for analytics

presented by Ashutosh Bapat from EnterpriseDB

Checkout the slides

Checkout the Video

PostgreSQL is first and foremost an OLTP DBMS. But it has a rich set of features which allows it to be used as an OLAP DBMS.

  • Highly compliant with SQL standard
  • Analytical features like windowing.
  • Many data t...
more

14:00 - 14:40 Grand Victoria B Application Developer
14:45
Nikita Malakhov

Roasted Toasted Json

presented by Nikita Malakhov from Postgres Professional

Checkout the slides

PostgreSQL is the first relational database recognized the need of non-atomic data types in application development from science to Web. Jsonb in Postgres is the attractive feature for modern application wanted by developers as Json documents with a strong consis...

more

14:45 - 15:25 Grand Victoria B Database Engine Developers
Shalaka Dengale

PostgreSQL Unboxed: Leveraging Containerization for Scalable Database Deployments

presented by Shalaka Dengale from AWS

Checkout the slides

In the evolving landscape of modern software deployment, containerization has emerged as a game-changer. This presentation delves into the realm of PostgreSQL deployment through containerization, exploring i...

more

14:45 - 15:25 Robusta + Arabica Database Administration
Rohan Kumar

Postgres Monitoring: A Practical Peek Under the Hood

presented by Rohan Kumar from

Checkout the slides

Abstract:

In this session, we will touch on the importance of PostgreSQL monitoring, even when you are using managed offerings like RDS, CloudSQL, etc. I will then delve into how we can leverage open-source tools like postgres_exporter,...

more

14:45 - 15:25 Grand Victoria A Database Administration
15:30
Justin George

How to Unleash the Power of PostgreSQL in the Cloud
How to Unleash the Power of PostgreSQL in the Cloud

presented by Justin George from Instaclustr by NetApp

Checkout the slides

PostgreSQL is a widely used database for high performance applications on premises. Migrating these applications to the cloud means you need to consider your cloud infrastructure options to deliver the highest performance available fo...

more

15:30 - 16:10 Grand Victoria B Database Administration
Luigi Nardi

PostgreSQL parameter performance optimization: From manual tuning to autotuning

presented by Luigi Nardi from DBtune

Checkout the slides

Explore the intricate world of PostgreSQL parameter tuning, where the database management system reveals a myriad of configurable parameters shaping its runtime behavior. With the evolution of the system, numerous parameters came to light — Correctly configuri...

more

15:30 - 16:10 Grand Victoria A Application Developer
Sameer Mannava

Using PostgreSQL and PostGIS for climate resilent agriculture

presented by Sameer Mannava from Indian Institute of Technology Bombay

Checkout the slides

At IIT Bombay, we are working with the Maharashtra Department of Agriculture on building climate resilience in agriculture of rural Maharashtra. A crucial input for agriculture is rainfall. We've built a model to compute di...

more

15:30 - 16:10 Robusta + Arabica Case Study
16:15
PGConf Organizers

Tea Break
Tea Break

presented by PGConf Organizers from PGConf India

30 minutes Tea Break

16:15 - 16:35 Grand Victoria Other
16:40
PGConf Organizers

Platinum Sponsor Keynote by EnterpriseDB
Platinum Sponsor Keynote by EnterpriseDB

presented by PGConf Organizers from PGConf India

Platinum Sponsor Keynote by EnterpriseDB

16:40 - 16:50 Grand Victoria Sponsor Keynote
16:50
PGConf Organizers

Platinum Sponsor Keynote by Tessell
Platinum Sponsor Keynote by Tessell

presented by PGConf Organizers from PGConf India

Platinum Sponsor Keynote by Tessell

16:50 - 17:00 Grand Victoria Sponsor Keynote
17:00
PGConf Organizers

Lightning Talks and Group Photo
Lightning Talks

presented by PGConf Organizers from PGConf India

Lightning Talks

17:00 - 18:00 Grand Victoria Other
19:00
PGConf Organizers

Conference Dinner @ Long Boat Brewing Company
Conference Dinner

presented by PGConf Organizers from PGConf India

Conference Dinner on Day 1 at Long Boat Brewing Company, 1st Main, MSR Layout, Chandra Layout, Marathahalli, Bengaluru, Karnataka 560037

19:00 - 22:00 Long Boat Brewing Company Other
2024-03-01
08:00
PGConf Organizers

Networking Over Breakfast
Networking Over Breakfast

presented by PGConf Organizers from PGConf India

Networking Over Breakfast

08:00 - 09:00 Grand Victoria Other
09:00
PGConf Organizers

Round Table Discussion
Round Table Discussion

presented by PGConf Organizers from PGConf India

A Round Table Discussion about how we can set up PostgreSQL to succeed in the near and distant future.

09:00 - 09:45 Grand Victoria Other
09:50
Subhash Guddad

AI everywhere with Google Cloud Databases
AI everywhere with Google Cloud Databases

presented by Subhash Guddad from Google

This sponsor keynote will focus on how Google Cloud is integrating AI in all of its database offerings including focus on PostgreSQL.

09:50 - 10:10 Grand Victoria Sponsor Keynote
10:10
PGConf Organizers

Diamond Sponsor Keynote by AWS
Diamond Sponsor Keynote by AWS

presented by PGConf Organizers from PGConf India

Diamond Sponsor Keynote by AWS

10:10 - 10:30 Grand Victoria Sponsor Keynote
10:30
PGConf Organizers

Tea Break
Tea Break

presented by PGConf Organizers from PGConf India

Tea Break in the morning on Day 2

10:30 - 10:50 Grand Victoria Other
10:50
Jim Mlodgenski

Writing fast trusted stored functions in PL/Rust

presented by Jim Mlodgenski from Amazon Web Services

Checkout the slides

One of PostgreSQL's superpowers is its ability for users to write stored procedures and functions in many different languages like plpglsql, Python, Javascript. They are all powerful in their own way, but they all are interpreted languages which comes...

more

10:50 - 11:30 Grand Victoria A Application Developer
Ujjwal Gupta

Use Connection Pooling to Enable Postgres Proxy and to Improve Database Performance

presented by Ujjwal Gupta from SquadStack

Checkout the slides

Use Connection Pooling to Enable Postgres Proxy and to Improve Database Performance

About:

  1. How we can use connection pooling to enable Postgres proxy?
  2. How we can use connection pooling to improve database performance?

Abstract:

We currently have a c...

more

10:50 - 11:30 Grand Victoria B Case Study
VaibhavJain Pushkar Khadilkar

Vector Embeddings and Vector search in PG
Vector Embeddings and Vector search in PG

presented by VaibhavJain, Pushkar Khadilkar from Google

Checkout the slides

strong text This talk will look at the following aspects:

  • Integration with LLMs
  • Generation of vector embeddings
  • Persistence of vector embeddings
  • Approximate Nearest Neighbor (ANN) Search

10:50 - 11:30 Robusta + Arabica Database Engine Developers
11:35
RK Rakesh

PostgreSQL I/O Patterns
Dive into PostgreSQL I/O

presented by RK Rakesh from Sr. Solutions Architect at Tessell Inc.

Checkout the slides

PostgreSQL I/O Patterns

In this talk, we would like to talk about PostgreSQL database systems I/O patterns. In PostgreSQL, we do have I/O patterns like

  • Checkpoint
  • Background Writer
  • Vacuum/Autovacuum
  • Client Backend
  • Bulk Read/Write...
more

11:35 - 12:15 Robusta + Arabica Case Study
Lalit Choudhary

PostgreSQL DBA's Troubleshooting Toolkit: Unraveling Complex Issues with Expertise.
PostgreSQL DBA's Troubleshooting Toolkit

presented by Lalit Choudhary from Percona

Checkout the slides

Objective: From this topic, DBA should know how to approach if they are looking for testing, reproducing issues, Health checks, and monitoring for PostgreSQL.

Talk abstract:

  • Introduction: The significance of testing and monitoring tools and...
more

11:35 - 12:15 Grand Victoria B Database Administration
Shruthi K C

PostgreSQL 16: What's New? A comprehensive overview of the Latest Features

presented by Shruthi K C from EnterpriseDB

Checkout the slides

Title: PostgreSQL 16: What's New? A comprehensive overview of the Latest Features

PostgreSQL 16 is here, and it's packed with exciting new features and improvements! If you're eager to dive in and start using this latest version of one of the world's most powerful open-source database...

more

11:35 - 12:15 Grand Victoria A Application Developer
12:20
Jobin Augustine

Most Common Mistakes and the Cost of Mistakes One Should Be Aware
Most Common Mistakes and the Cost of Mistakes One Should Be Aware

presented by Jobin Augustine from Percona

Checkout the slides

###Introduction The presenter has a unique opportunity to address hundreds of real-world, escalated issues from different users as part of the job. This gave a realisation that many are often running into a group of common mistakes. It will be of great value if Postgre...

more

12:20 - 13:00 Robusta + Arabica Database Administration
Ben Darnell

Various Isolation Levels in Relational Database Management Systems
Various Isolation Levels in Relational Database Management Systems

presented by Ben Darnell from Cockroach Labs

Checkout the slides

Transaction isolation levels are officially defined in terms of which data anomalies they prevent. However, terms like “phantom read” are difficult to understand and are not helpful to most application developers trying to choose the right level. Fort...

more

12:20 - 13:00 Grand Victoria B Database Administration
Tom Howcroft

Unlocking financial DevOps: Navigating the FinOps landscape for cloud cost optimization in PostgreSQL

presented by Tom Howcroft from DBtune

Checkout the slides

In the dynamic realm of contemporary computing, Financial DevOps (FinOps) has emerged as a focal point, responding to the escalating challenges of cloud costs. Despite the initial promise of reduced infrastructure expenses, organizations are establishing FinOps departments ...

more

12:20 - 13:00 Grand Victoria A Case Study
13:05
PGConf Organizers

Day 2 Lunch
Day 2 Lunch

presented by PGConf Organizers from PGConf India

Day 2 Lunch

13:05 - 14:00 Grand Victoria Other
14:00
Bruce Momjian

MVCC Unmasked

presented by Bruce Momjian from EnterpriseDB

Checkout the slides

Multi-Version Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimization...

more

14:00 - 14:40 Grand Victoria B Database Engine Developers
Varun Dhawan

Transforming PostgreSQL to API: A Simplified Journey with Data API Builder
Easy API Creation with PostgreSQL and Data API Builder

presented by Varun Dhawan from Microsoft

Checkout the slides

Dive into a realm of innovation where PostgreSQL meets modern API technologies, orchestrated by the versatile Microsoft’s open-source project Data API Builder (DAB). Tailored for PostgreSQL Application Developers, this session is set to unravel the seam...

more

14:00 - 14:40 Robusta + Arabica Application Developer
Peter Farkas

Moving MongoDB Workloads to PostgreSQL

presented by Peter Farkas from FerretDB

Checkout the slides

MongoDB, a widely used database, has garnered both love and hate from its users across different industries due to its ease of use. However, it is no longer open source, faces licensing issues, and requires additional resources and knowledge to run. Is there a...

more

14:00 - 14:40 Grand Victoria A Case Study
14:45
Avinash Shashikant Dalvi

Harnessing the power of Postgres for GIS
Using Postgres database for GIS case study

presented by Avinash Shashikant Dalvi from Eagleview

Checkout the slides

In this talk, we will discuss the benefits of using Postgres for GIS and how to harness the power of Postgres for your GIS applications. We will cover the following topics:

  • Overview of Postgres and PostGIS
  • Storing and querying geospatial data in Postgres -...
more

14:45 - 15:25 Grand Victoria B Case Study
Pavish Kumar R

Making PostgreSQL accessible to your non-technical colleagues

presented by Pavish Kumar R from Mathesar

Checkout the slides

Every application developer and DB admin comes across the scenario where you're expected to be an intermediary between the database and your non-technical colleagues.

Have you ever faced these situations:

  • Run queries to answer questions for bus...
more

14:45 - 15:25 Robusta + Arabica Case Study
Darshan Balar

Real Time Data processing using Go and PostgreSQL

presented by Darshan Balar from Indiamart

Checkout the slides

Abstract:

In the digital age, data flows incessantly, and for many applications, the ability to harness this continuous stream of information in real-time is the key to gaining valuable insights and staying competitive. To address thi...

more

14:45 - 15:25 Grand Victoria A Application Developer
15:30
PGConf Organizers

Tea Break
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

Lightning Talks and Closing Note
Lightning Talks and Closing Note

presented by PGConf Organizers from PGConf India

Lightning Talks and Closing Note

16:00 - 17:00 Grand Victoria Other