Program for PGConf India, 2024
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 OtherMaintaining 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 TrainingPostgres 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 TrainingBuilding 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 TrainingMastering 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 TrainingTraining Day Lunch
Training Day Lunch
presented by PGConf Organizers from PGConf India
Training Day Lunch
13:00 - 13:55 Grand Victoria OtherPostgreSQL 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...
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 TrainingDistributed 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 TrainingPostgreSQL 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.
Gain a comprehensive understanding of PostgreSQL extensions and their role in expanding database functionalities.
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 TrainingConference 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 OtherOpening Remarks
Opening Remarks
presented by PGConf Organizers from PGConf India
Welcome Note
09:00 - 09:15 Grand Victoria OtherREPLACEMENT Please note that this talk replaces Postgres Challenges, Commercial & Community; Past, Present & Future
Through the eyes of a long time Indian Community ContributorThrough 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 KeynoteThrough 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 KeynoteAll 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 KeynoteTea Break
Tea Break
presented by PGConf Organizers from PGConf India
Day 1 Morning Tea Break
10:20 - 10:50 Grand Victoria OtherIncremental 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 DevelopersSeamlessly 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 AdministrationA 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 DevelopersFinding 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 Developerpg_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 AdministrationIncremental 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 StudyUnlocking 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 DeveloperYDB — 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 DevelopersPostgres 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 AdministrationDay 1 Lunch
Day 1 Lunch
presented by PGConf Organizers from PGConf India
Lunch on Day 1
13:05 - 14:00 Grand Victoria OtherAn 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 DeveloperWhy 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 AdministrationPostgres 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...
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 DevelopersPostgreSQL 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 AdministrationPostgres 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 AdministrationHow 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 AdministrationPostgreSQL 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 DeveloperUsing 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 StudyTea Break
Tea Break
presented by PGConf Organizers from PGConf India
30 minutes Tea Break
16:15 - 16:35 Grand Victoria OtherPlatinum 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 KeynotePlatinum 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 KeynoteLightning Talks and Group Photo
Lightning Talks
presented by PGConf Organizers from PGConf India
Lightning Talks
17:00 - 18:00 Grand Victoria OtherConference 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 OtherNetworking Over Breakfast
Networking Over Breakfast
presented by PGConf Organizers from PGConf India
Networking Over Breakfast
08:00 - 09:00 Grand Victoria OtherRound 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 OtherAI 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 KeynoteDiamond 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 KeynoteTea Break
Tea Break
presented by PGConf Organizers from PGConf India
Tea Break in the morning on Day 2
10:30 - 10:50 Grand Victoria OtherWriting 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 DeveloperUse 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:
- How we can use connection pooling to enable Postgres proxy?
- 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 StudyVector 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
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...
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...
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 DeveloperMost 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 AdministrationVarious 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 AdministrationUnlocking 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 StudyDay 2 Lunch
Day 2 Lunch
presented by PGConf Organizers from PGConf India
Day 2 Lunch
13:05 - 14:00 Grand Victoria OtherMVCC 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 DevelopersTransforming 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 DeveloperMoving 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 StudyHarnessing 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 -...
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...
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 DeveloperTea Break
Tea Break
presented by PGConf Organizers from PGConf India
Day 2 afternoon tea break
15:30 - 16:00 Grand Victoria OtherLightning 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